Back to OIM Explorer

dbo.TSB_TDUNSGroupB1Exclusion

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on UNSGroupB1Exclusion. Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 8; Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB1 / TSB_ZOrgHasUNSGroupB1 at line 8; Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB1 / TSB_ZOrgHasUNSGroupB1 at line 11; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 1.719 characters

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-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 8
  • Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB1 / TSB_ZOrgHasUNSGroupB1 at line 8
  • Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB1 / TSB_ZOrgHasUNSGroupB1 at line 11
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: UNSGroupB1Exclusion

Typed Edges

  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB1 at line 8 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 8
  • queues DBQueue task TSB_ZOrgHasUNSGroupB1 at line 8 Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB1 / TSB_ZOrgHasUNSGroupB1 at line 8
  • queues DBQueue task TSB_ZOrgHasUNSGroupB1 at line 11 Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB1 / TSB_ZOrgHasUNSGroupB1 at line 11
  • trigger on table UNSGroupB1Exclusion Trigger parent table: UNSGroupB1Exclusion
  • 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_TDUNSGroupB source text reference
  • references source dbo.TSB_TDUNSGroupB1 source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL78 lines
1CREATE trigger TSB_TDUNSGroupB1Exclusion2  ON UNSGroupB1Exclusion FOR3DELETE NOT FOR Replication4AS5BEGIN6  BEGIN TRY7    IF EXISTS(8      SELECT TOP 1 19      FROM deleted)10    GOTO start11    RETURN start:12    DECLARE @GenProcID varchar(38)13    SELECT @GenProcID = dbo.QBM_FGISessionContext('')14    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw15    INSERT INTO @DBQueueElements_01(object,16    subobject,17    genprocid)18    SELECT19      x.uid,20      NULL,21      @GenProcID22    FROM(23    SELECT uig.UID_UNSAccountB AS uid24    FROM(25    SELECT UID_UNSGroupB1Lower AS UID_UNSGroupB126    FROM deleted27    UNION28    SELECT UID_UNSGroupB1Higher29    FROM deleted) AS y30    JOIN UNSGroupB1Collection coll31      ON y.uid_UNSGroupB1 = coll.UID_UNSGroupB1Parent32    JOIN UNSAccountBInUNSGroupB1 uig33      ON coll.UID_UNSGroupB1Child = uig.uid_UNSGroupB134    UNION35    SELECT uig.UID_UNSAccountB AS uid36    FROM(37    SELECT UID_UNSGroupB1Lower AS UID_UNSGroupB138    FROM deleted39    UNION40    SELECT UID_UNSGroupB1Higher41    FROM deleted) AS y42    JOIN UNSGroupB1Collection coll43      ON y.uid_UNSGroupB1 = coll.UID_UNSGroupB1Parent44    JOIN UNSAccountBHasUNSGroupB1 uig45      ON coll.UID_UNSGroupB1Child = uig.uid_UNSGroupB1) AS x46    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB1',47      @DBQueueElements_0148    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw49    INSERT INTO @DBQueueElements_02(object,50    subobject,51    genprocid)52    SELECT53      x.uid,54      NULL,55      @GenProcID56    FROM(57    SELECT g.UID_Org AS uid58    FROM(59    SELECT UID_UNSGroupB1Lower AS UID_UNSGroupB160    FROM deleted61    UNION62    SELECT UID_UNSGroupB1Higher63    FROM deleted) AS y64    JOIN BaseTreeHasUNSGroupB1 g65      ON y.UID_UNSGroupB1 = g.UID_UNSGroupB1) AS x66    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-OrgHasUNSGroupB1',67      @DBQueueElements_0268  END TRY69  BEGIN CATCH70    EXEC QBM_PSessionErrorAdd DEFAULT71    RAISERROR('',72    18,73    1)74      WITH NOWAIT75  END CATCH76  ende:77  RETURN78END
Open raw exported source
SQL ยท Raw13 lines
1create   trigger TSB_TDUNSGroupB1Exclusion on UNSGroupB1Exclusion  for Delete not for Replication as begin  BEGIN TRY if exists (select top 21 1 from deleted) goto start return start:  declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') declare @DBQueueElements_013 QBM_YDBQueueRaw  insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uig.UID_UNSAccountB as uid4 from ( select UID_UNSGroupB1Lower as UID_UNSGroupB1 from deleted union select UID_UNSGroupB1Higher from deleted ) as y  join UNSGroupB1Collection5 coll on y.uid_UNSGroupB1 = coll.UID_UNSGroupB1Parent join UNSAccountBInUNSGroupB1 uig on coll.UID_UNSGroupB1Child = uig.uid_UNSGroupB1    union6 select uig.UID_UNSAccountB as uid from ( select UID_UNSGroupB1Lower as UID_UNSGroupB1 from deleted union select UID_UNSGroupB1Higher from deleted7 ) as y  join UNSGroupB1Collection coll on y.uid_UNSGroupB1 = coll.UID_UNSGroupB1Parent join UNSAccountBHasUNSGroupB1 uig on coll.UID_UNSGroupB1Child8 = uig.uid_UNSGroupB1  ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB1', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw9 insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select g.UID_Org as uid from ( select UID_UNSGroupB1Lower10 as UID_UNSGroupB1 from deleted union select UID_UNSGroupB1Higher from deleted ) as y join BaseTreeHasUNSGroupB1 g on y.UID_UNSGroupB1 = g.UID_UNSGroupB111 ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-OrgHasUNSGroupB1', @DBQueueElements_02  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (12'', 18, 1) WITH NOWAIT END CATCH ende: return end 13