Back to OIM Explorer

dbo.TSB_TDUNSGroupB3Exclusion

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on UNSGroupB3Exclusion. Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 8; Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB3 / TSB_ZOrgHasUNSGroupB3 at line 8; Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB3 / TSB_ZOrgHasUNSGroupB3 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-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 8
  • Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB3 / TSB_ZOrgHasUNSGroupB3 at line 8
  • Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB3 / TSB_ZOrgHasUNSGroupB3 at line 11
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: UNSGroupB3Exclusion

Typed Edges

  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB3 at line 8 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 8
  • queues DBQueue task TSB_ZOrgHasUNSGroupB3 at line 8 Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB3 / TSB_ZOrgHasUNSGroupB3 at line 8
  • queues DBQueue task TSB_ZOrgHasUNSGroupB3 at line 11 Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB3 / TSB_ZOrgHasUNSGroupB3 at line 11
  • trigger on table UNSGroupB3Exclusion Trigger parent table: UNSGroupB3Exclusion
  • 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_TDUNSGroupB3 source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL78 lines
1CREATE trigger TSB_TDUNSGroupB3Exclusion2  ON UNSGroupB3Exclusion 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_UNSGroupB3Lower AS UID_UNSGroupB326    FROM deleted27    UNION28    SELECT UID_UNSGroupB3Higher29    FROM deleted) AS y30    JOIN UNSGroupB3Collection coll31      ON y.uid_UNSGroupB3 = coll.UID_UNSGroupB3Parent32    JOIN UNSAccountBInUNSGroupB3 uig33      ON coll.UID_UNSGroupB3Child = uig.uid_UNSGroupB334    UNION35    SELECT uig.UID_UNSAccountB AS uid36    FROM(37    SELECT UID_UNSGroupB3Lower AS UID_UNSGroupB338    FROM deleted39    UNION40    SELECT UID_UNSGroupB3Higher41    FROM deleted) AS y42    JOIN UNSGroupB3Collection coll43      ON y.uid_UNSGroupB3 = coll.UID_UNSGroupB3Parent44    JOIN UNSAccountBHasUNSGroupB3 uig45      ON coll.UID_UNSGroupB3Child = uig.uid_UNSGroupB3) AS x46    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB3',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_UNSGroupB3Lower AS UID_UNSGroupB360    FROM deleted61    UNION62    SELECT UID_UNSGroupB3Higher63    FROM deleted) AS y64    JOIN BaseTreeHasUNSGroupB3 g65      ON y.UID_UNSGroupB3 = g.UID_UNSGroupB3) AS x66    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-OrgHasUNSGroupB3',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_TDUNSGroupB3Exclusion on UNSGroupB3Exclusion  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_UNSGroupB3Lower as UID_UNSGroupB3 from deleted union select UID_UNSGroupB3Higher from deleted ) as y  join UNSGroupB3Collection5 coll on y.uid_UNSGroupB3 = coll.UID_UNSGroupB3Parent join UNSAccountBInUNSGroupB3 uig on coll.UID_UNSGroupB3Child = uig.uid_UNSGroupB3    union6 select uig.UID_UNSAccountB as uid from ( select UID_UNSGroupB3Lower as UID_UNSGroupB3 from deleted union select UID_UNSGroupB3Higher from deleted7 ) as y  join UNSGroupB3Collection coll on y.uid_UNSGroupB3 = coll.UID_UNSGroupB3Parent join UNSAccountBHasUNSGroupB3 uig on coll.UID_UNSGroupB3Child8 = uig.uid_UNSGroupB3  ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB3', @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_UNSGroupB3Lower10 as UID_UNSGroupB3 from deleted union select UID_UNSGroupB3Higher from deleted ) as y join BaseTreeHasUNSGroupB3 g on y.UID_UNSGroupB3 = g.UID_UNSGroupB311 ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-OrgHasUNSGroupB3', @DBQueueElements_02  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (12'', 18, 1) WITH NOWAIT END CATCH ende: return end 13