Back to OIM Explorer

dbo.TSB_TIUNSGroupB2Collection

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on UNSGroupB2Collection. Bulk DBQueue insert -> TSB-K-PersonHasObject / TSB_ZPersonHasObject at line 8; Bulk DBQueue insert -> TSB-K-BaseTreeHasObject / TSB_ZBaseTreeHasObject at line 8; Bulk DBQueue insert -> TSB-K-BaseTreeHasObject / TSB_ZBaseTreeHasObject at line 11; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 1.748 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-PersonHasObject / TSB_ZPersonHasObject at line 8
  • Bulk DBQueue insert -> TSB-K-BaseTreeHasObject / TSB_ZBaseTreeHasObject at line 8
  • Bulk DBQueue insert -> TSB-K-BaseTreeHasObject / TSB_ZBaseTreeHasObject at line 11
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: UNSGroupB2Collection

Typed Edges

  • queues DBQueue task TSB_ZPersonHasObject at line 8 Bulk DBQueue insert -> TSB-K-PersonHasObject / TSB_ZPersonHasObject at line 8
  • queues DBQueue task TSB_ZBaseTreeHasObject at line 8 Bulk DBQueue insert -> TSB-K-BaseTreeHasObject / TSB_ZBaseTreeHasObject at line 8
  • queues DBQueue task TSB_ZBaseTreeHasObject at line 11 Bulk DBQueue insert -> TSB-K-BaseTreeHasObject / TSB_ZBaseTreeHasObject at line 11
  • trigger on table UNSGroupB2Collection Trigger parent table: UNSGroupB2Collection
  • 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 source dbo.TSB_TIUNSGroupB2 source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL83 lines
1CREATE trigger TSB_TIUNSGroupB2Collection2  ON UNSGroupB2Collection FOR3INSERT NOT FOR Replication4AS5BEGIN6  IF EXISTS(7    SELECT TOP 1 18    FROM inserted)9  GOTO start10  RETURN start:11  BEGIN TRY12    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 a.uid_person AS uid24    FROM UNSAccountBInUNSGroupB2 uig25    JOIN(26    SELECT uid_UNSGroupB2Parent AS UID_Group27    FROM inserted28    UNION29    SELECT UID_UNSGroupB2Child30    FROM inserted) AS x31      ON x.uid_group = uig.uid_UNSGroupB2 AND uig.XOrigin > 032    JOIN UNSAccountB a33      ON uig.UID_UNSAccountB = a.uid_UNSAccountB34    WHERE35      a.uid_person > ' '36    UNION37    SELECT a.uid_person AS uid38    FROM UNSAccountBHasUNSGroupB2 uig39    JOIN(40    SELECT uid_UNSGroupB2Parent AS UID_Group41    FROM inserted42    UNION43    SELECT UID_UNSGroupB2Child44    FROM inserted) AS x45      ON x.uid_group = uig.uid_UNSGroupB2 AND uig.XOrigin > 046    JOIN UNSAccountB a47      ON uig.UID_UNSAccountB = a.uid_UNSAccountB48    WHERE49      a.uid_person > ' ') AS x50    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-PersonHasObject',51      @DBQueueElements_0152    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw53    INSERT INTO @DBQueueElements_02(object,54    subobject,55    genprocid)56    SELECT57      x.uid,58      NULL,59      @GenProcID60    FROM(61    SELECT62      DISTINCT uig.UID_Org AS uid63    FROM BaseTreeHasUNSGroupB2 uig64    JOIN(65    SELECT uid_UNSGroupB2Parent AS UID_Group66    FROM inserted67    UNION68    SELECT UID_UNSGroupB2Child69    FROM inserted) AS x70      ON x.uid_group = uig.uid_UNSGroupB2 AND uig.XOrigin > 0) AS x71    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-BaseTreeHasObject',72      @DBQueueElements_0273  END TRY74  BEGIN CATCH75    EXEC QBM_PSessionErrorAdd DEFAULT76    RAISERROR('',77    18,78    1)79      WITH NOWAIT80  END CATCH81  ende:82  RETURN83END
Open raw exported source
SQL ยท Raw13 lines
1  create   trigger TSB_TIUNSGroupB2Collection on UNSGroupB2Collection  for Insert not for Replication as begin  if exists (select top 1 1 from2 inserted) goto start return start: BEGIN TRY 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  a.uid_person as uid from 4UNSAccountBInUNSGroupB2 uig join (select uid_UNSGroupB2Parent as UID_Group from inserted union select UID_UNSGroupB2Child from inserted ) as x on5 x.uid_group = uig.uid_UNSGroupB2 and uig.XOrigin > 0  join UNSAccountB a on uig.UID_UNSAccountB = a.uid_UNSAccountB where a.uid_person > ' '  union 6select a.uid_person as uid from UNSAccountBHasUNSGroupB2 uig join (select uid_UNSGroupB2Parent as UID_Group from inserted union select UID_UNSGroupB2Child7 from inserted ) as x on x.uid_group = uig.uid_UNSGroupB2 and uig.XOrigin > 0  join UNSAccountB a on uig.UID_UNSAccountB = a.uid_UNSAccountB where a.uid_person8 > ' '  ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-PersonHasObject', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_029 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct uig.UID_Org as uid from BaseTreeHasUNSGroupB2 uig join (select 10uid_UNSGroupB2Parent as UID_Group from inserted union select UID_UNSGroupB2Child from inserted ) as x on x.uid_group = uig.uid_UNSGroupB2 and uig.XOrigin11 > 0  ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-BaseTreeHasObject', @DBQueueElements_02 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR12 ('', 18, 1) WITH NOWAIT END CATCH ende: return end 13