dbo.TSB_TIUNSGroupBHasUNSItemB
Database TriggerSQL_TRIGGERSandbox DB
Interpretation
- Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.
- DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.
Relations
- Bulk DBQueue insert -> TSB-K-UNSGroupBHasUNSItemB / TSB_ZUNSGroupBHasUNSItemB at line 5
- Bulk DBQueue insert -> TSB-K-UNSAccountBHasUNSItemB / TSB_ZUNSAccountBHasUNSItemB at line 5
- Bulk DBQueue insert -> TSB-K-UNSGroupBHasUNSItemB / TSB_ZUNSGroupBHasUNSItemB at line 5
- Bulk DBQueue insert -> TSB-K-UNSAccountBHasUNSItemB / TSB_ZUNSAccountBHasUNSItemB at line 8
- Bulk DBQueue insert -> TSB-K-UNSGroupBHasUNSItemB / TSB_ZUNSGroupBHasUNSItemB at line 8
- Bulk DBQueue insert -> TSB-K-UNSGroupBHasUNSItemB / TSB_ZUNSGroupBHasUNSItemB at line 11
- References QBM_PDBQueueInsert_Bulk
- Trigger parent table: UNSGroupBHasUnsItemB
Typed Edges
- queues DBQueue task TSB_ZUNSGroupBHasUNSItemB at line 5 Bulk DBQueue insert -> TSB-K-UNSGroupBHasUNSItemB / TSB_ZUNSGroupBHasUNSItemB at line 5
- queues DBQueue task TSB_ZUNSAccountBHasUNSItemB at line 5 Bulk DBQueue insert -> TSB-K-UNSAccountBHasUNSItemB / TSB_ZUNSAccountBHasUNSItemB at line 5
- queues DBQueue task TSB_ZUNSAccountBHasUNSItemB at line 8 Bulk DBQueue insert -> TSB-K-UNSAccountBHasUNSItemB / TSB_ZUNSAccountBHasUNSItemB at line 8
- queues DBQueue task TSB_ZUNSGroupBHasUNSItemB at line 8 Bulk DBQueue insert -> TSB-K-UNSGroupBHasUNSItemB / TSB_ZUNSGroupBHasUNSItemB at line 8
- queues DBQueue task TSB_ZUNSGroupBHasUNSItemB at line 11 Bulk DBQueue insert -> TSB-K-UNSGroupBHasUNSItemB / TSB_ZUNSGroupBHasUNSItemB at line 11
- trigger on table UNSGroupBHasUnsItemB Trigger parent table: UNSGroupBHasUnsItemB
- references source dbo.QBM_FGIBitPatternXOrigin source text reference
- references source dbo.QBM_FGISessionContext source text reference
- references source dbo.QBM_PDBQueueInsert_Bulk source text reference
- references source dbo.QBM_PSessionErrorAdd source text reference
- references source dbo.TSB_TIUNSGroupB source text reference
References
- dbo.QBM_FGIBitPatternXOrigin
- dbo.QBM_FGISessionContext
- dbo.QBM_PDBQueueInsert_Bulk
- dbo.QBM_PSessionErrorAdd
- dbo.TSB_TIUNSGroupB
Referenced By
- No direct source references extracted.
Complete Source
1CREATE trigger TSB_TIUNSGroupBHasUNSItemB2 ON UNSGroupBHasUNSItemB FOR3INSERT NOT FOR Replication4AS5BEGIN6 DECLARE @QBM_BitPatternXOrigin_Inherit_inv int = dbo.QBM_FGIBitPatternXOrigin('|Inherit|',7 1)8 BEGIN TRY9 IF EXISTS(10 SELECT TOP 1 111 FROM inserted)12 GOTO start13 RETURN start:14 DECLARE @GenProcID varchar(38)15 SELECT @GenProcID = dbo.QBM_FGISessionContext('')16 DECLARE @DBQueueElements_01 QBM_YDBQueueRaw17 INSERT INTO @DBQueueElements_01(object,18 subobject,19 genprocid)20 SELECT21 x.uid,22 NULL,23 @GenProcID24 FROM(25 SELECT26 DISTINCT i.UID_UNSGroupB AS uid27 FROM inserted i28 WHERE29 i.XOrigin & @QBM_BitPatternXOrigin_Inherit_inv > 0) AS x30 EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSGroupBHasUNSItemB',31 @DBQueueElements_0132 DECLARE @DBQueueElements_02 QBM_YDBQueueRaw33 INSERT INTO @DBQueueElements_02(object,34 subobject,35 genprocid)36 SELECT37 x.uid,38 NULL,39 @GenProcID40 FROM(41 SELECT t.UID_UNSAccountB AS uid42 FROM inserted m43 JOIN UnsAccountBinUnsGroupB t44 ON m.uid_UnsGroupB = t.uid_UnsGroupB AND t.XOrigin > 045 WHERE46 m.XIsInEffect = 147 UNION48 SELECT t.UID_UNSAccountB AS uid49 FROM inserted m50 JOIN UNSAccountBHasUNSGroupB t51 ON m.UID_UNSGroupB = t.UID_UNSGroupB AND t.XOrigin > 052 WHERE53 m.XIsInEffect = 1) AS x54 EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBHasUNSItemB',55 @DBQueueElements_0256 DECLARE @DBQueueElements_03 QBM_YDBQueueRaw57 INSERT INTO @DBQueueElements_03(object,58 subobject,59 genprocid)60 SELECT61 x.uid,62 NULL,63 @GenProcID64 FROM(65 SELECT66 DISTINCT t.UID_UNSGroupBChild AS uid67 FROM inserted m68 JOIN UnsGroupBinUnsGroupB t69 ON m.uid_UnsGroupB = t.uid_UnsGroupBParent70 WHERE71 m.XIsInEffect = 1) AS x72 EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSGroupBHasUNSItemB',73 @DBQueueElements_0374 END TRY75 BEGIN CATCH76 EXEC QBM_PSessionErrorAdd DEFAULT77 RAISERROR('',78 18,79 1)80 WITH NOWAIT81 END CATCH82 ende:83 RETURN84ENDOpen raw exported source
1 create trigger TSB_TIUNSGroupBHasUNSItemB on UNSGroupBHasUNSItemB for Insert not for Replication as begin declare @QBM_BitPatternXOrigin_Inherit_inv2 int = dbo.QBM_FGIBitPatternXOrigin('|Inherit|', 1) BEGIN TRY if exists (select top 1 1 from inserted) goto start return start: declare @GenProcID varchar3(38) select @GenProcID = dbo.QBM_FGISessionContext('') declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, 4genprocid) select x.uid, null, @GenProcID from ( select distinct i.UID_UNSGroupB as uid from inserted i where i.XOrigin & @QBM_BitPatternXOrigin_Inherit_inv5 > 0 ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSGroupBHasUNSItemB', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_026 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select t.UID_UNSAccountB as uid from inserted m join UnsAccountBinUnsGroupB t on7 m.uid_UnsGroupB = t.uid_UnsGroupB and t.XOrigin > 0 where m.XIsInEffect = 1 union select t.UID_UNSAccountB as uid from inserted m join UNSAccountBHasUNSGroupB8 t on m.UID_UNSGroupB = t.UID_UNSGroupB and t.XOrigin > 0 where m.XIsInEffect = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBHasUNSItemB',9 @DBQueueElements_02 declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID10 from ( select distinct t.UID_UNSGroupBChild as uid from inserted m join UnsGroupBinUnsGroupB t on m.uid_UnsGroupB = t.uid_UnsGroupBParent where m.XIsInEffect11 = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSGroupBHasUNSItemB', @DBQueueElements_03 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR12 ('', 18, 1) WITH NOWAIT END CATCH ende: return end 13