Back to OIM Explorer

dbo.TSB_TITSBSpecificGroupBehavior

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on TSBSpecificGroupBehavior. Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB / TSB_ZUNSAccountBInUNSGroupB at line 6; Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 6; Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 6; Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 6

Source: sandbox-db sys.sql_modules

Source size: 3.274 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-UNSAccountBInUNSGroupB / TSB_ZUNSAccountBInUNSGroupB at line 6
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 6
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 6
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 6
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 11
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 11
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 11
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 15
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 15
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 20
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: TSBSpecificGroupBehavior

Typed Edges

  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB at line 6 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB / TSB_ZUNSAccountBInUNSGroupB at line 6
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB1 at line 6 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 6
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB2 at line 6 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 6
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB3 at line 6 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 6
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB1 at line 11 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 11
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB2 at line 11 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 11
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB3 at line 11 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 11
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB2 at line 15 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 15
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB3 at line 15 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 15
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB3 at line 20 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 20
  • trigger on table TSBSpecificGroupBehavior Trigger parent table: TSBSpecificGroupBehavior
  • 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

Referenced By

  • No direct source references extracted.

Complete Source

SQL139 lines
1CREATE trigger TSB_TITSBSpecificGroupBehavior2  ON TSBSpecificGroupBehavior FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    RETURN start:13    DECLARE @GUIDUnsGroupB00 QBM_YSingleGUID14    INSERT INTO @GUIDUnsGroupB00(UID_SingleGuid)15    SELECT g.UID_UNSGroupB16    FROM UNSGroupB g17    JOIN inserted i18      ON g.XObjectKey = i.ObjectKeyGroup19    IF @@ROWCOUNT > 020    BEGIN21      DECLARE @DBQueueElements_00 QBM_YDBQueueRaw22      INSERT INTO @DBQueueElements_00(object,23      subobject,24      genprocid)25      SELECT26        x.uid,27        NULL,28        @GenProcID29      FROM(30      SELECT uig.UID_UNSAccountB AS uid31      FROM UNSAccountBInUNSGroupB uig32      JOIN @GUIDUnsGroupB00 gg33        ON uig.UID_UNSGroupB = gg.UID_SingleGuid34      UNION35      SELECT uig.UID_UNSAccountB AS uid36      FROM UNSAccountBHasUNSGroupB uig37      JOIN @GUIDUnsGroupB00 gg38        ON uig.UID_UNSGroupB = gg.UID_SingleGuid) AS x39      EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB',40        @DBQueueElements_0041    END42    DECLARE @GUIDUnsGroupB01 QBM_YSingleGUID43    INSERT INTO @GUIDUnsGroupB01(UID_SingleGuid)44    SELECT g.UID_UNSGroupB145    FROM UNSGroupB1 g46    JOIN inserted i47      ON g.XObjectKey = i.ObjectKeyGroup48    IF @@ROWCOUNT > 049    BEGIN50      DECLARE @DBQueueElements_01 QBM_YDBQueueRaw51      INSERT INTO @DBQueueElements_01(object,52      subobject,53      genprocid)54      SELECT55        x.uid,56        NULL,57        @GenProcID58      FROM(59      SELECT uig.UID_UNSAccountB AS uid60      FROM UNSAccountBInUNSGroupB1 uig61      JOIN @GUIDUnsGroupB01 gg62        ON uig.UID_UNSGroupB1 = gg.UID_SingleGuid63      UNION64      SELECT uig.UID_UNSAccountB AS uid65      FROM UNSAccountBHasUNSGroupB1 uig66      JOIN @GUIDUnsGroupB01 gg67        ON uig.UID_UNSGroupB1 = gg.UID_SingleGuid) AS x68      EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB1',69        @DBQueueElements_0170    END71    DECLARE @GUIDUnsGroupB02 QBM_YSingleGUID72    INSERT INTO @GUIDUnsGroupB02(UID_SingleGuid)73    SELECT g.UID_UNSGroupB274    FROM UNSGroupB2 g75    JOIN inserted i76      ON g.XObjectKey = i.ObjectKeyGroup77    IF @@ROWCOUNT > 078    BEGIN79      DECLARE @DBQueueElements_02 QBM_YDBQueueRaw80      INSERT INTO @DBQueueElements_02(object,81      subobject,82      genprocid)83      SELECT84        x.uid,85        NULL,86        @GenProcID87      FROM(88      SELECT uig.UID_UNSAccountB AS uid89      FROM UNSAccountBInUNSGroupB2 uig90      JOIN @GUIDUnsGroupB02 gg91        ON uig.UID_UNSGroupB2 = gg.UID_SingleGuid92      UNION93      SELECT uig.UID_UNSAccountB AS uid94      FROM UNSAccountBHasUNSGroupB2 uig95      JOIN @GUIDUnsGroupB02 gg96        ON uig.UID_UNSGroupB2 = gg.UID_SingleGuid) AS x97      EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB2',98        @DBQueueElements_0299    END100    DECLARE @GUIDUnsGroupB03 QBM_YSingleGUID101    INSERT INTO @GUIDUnsGroupB03(UID_SingleGuid)102    SELECT g.UID_UNSGroupB3103    FROM UNSGroupB3 g104    JOIN inserted i105      ON g.XObjectKey = i.ObjectKeyGroup106    IF @@ROWCOUNT > 0107    BEGIN108      DECLARE @DBQueueElements_03 QBM_YDBQueueRaw109      INSERT INTO @DBQueueElements_03(object,110      subobject,111      genprocid)112      SELECT113        x.uid,114        NULL,115        @GenProcID116      FROM(117      SELECT uig.UID_UNSAccountB AS uid118      FROM UNSAccountBInUNSGroupB3 uig119      JOIN @GUIDUnsGroupB03 gg120        ON uig.UID_UNSGroupB3 = gg.UID_SingleGuid121      UNION122      SELECT uig.UID_UNSAccountB AS uid123      FROM UNSAccountBHasUNSGroupB3 uig124      JOIN @GUIDUnsGroupB03 gg125        ON uig.UID_UNSGroupB3 = gg.UID_SingleGuid) AS x126      EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB3',127        @DBQueueElements_03128    END129  END TRY130  BEGIN CATCH131    EXEC QBM_PSessionErrorAdd DEFAULT132    RAISERROR('',133    18,134    1)135      WITH NOWAIT136  END CATCH137  ende:138  RETURN139END
Open raw exported source
SQL ยท Raw22 lines
1 create   trigger TSB_TITSBSpecificGroupBehavior on TSBSpecificGroupBehavior  for insert not for Replication as begin declare @GenProcID varchar2(38) = dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from inserted) goto start return start: declare @GUIDUnsGroupB00 QBM_YSingleGUID3 insert into @GUIDUnsGroupB00(UID_SingleGuid) select g.UID_UNSGroupB from UNSGroupB g join inserted i on g.XObjectKey = i.ObjectKeyGroup if @@ROWCOUNT 4> 0 begin declare @DBQueueElements_00 QBM_YDBQueueRaw insert into @DBQueueElements_00 (object, subobject, genprocid) select x.uid, null, @GenProcID from5 ( select uig.UID_UNSAccountB as uid from UNSAccountBInUNSGroupB uig join @GUIDUnsGroupB00 gg on uig.UID_UNSGroupB = gg.UID_SingleGuid union select uig.UID_UNSAccountB6 as uid from UNSAccountBHasUNSGroupB uig join @GUIDUnsGroupB00 gg on uig.UID_UNSGroupB = gg.UID_SingleGuid ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB'7, @DBQueueElements_00 end  declare @GUIDUnsGroupB01 QBM_YSingleGUID insert into @GUIDUnsGroupB01(UID_SingleGuid) select g.UID_UNSGroupB1 from UNSGroupB18 g join inserted i on g.XObjectKey = i.ObjectKeyGroup if @@ROWCOUNT > 0 begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_019 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uig.UID_UNSAccountB as uid from UNSAccountBInUNSGroupB1 uig join @GUIDUnsGroupB0110 gg on uig.UID_UNSGroupB1 = gg.UID_SingleGuid union select uig.UID_UNSAccountB as uid from UNSAccountBHasUNSGroupB1 uig join @GUIDUnsGroupB01 gg on uig.UID_UNSGroupB111 = gg.UID_SingleGuid ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB1', @DBQueueElements_01 end  declare @GUIDUnsGroupB02 QBM_YSingleGUID12 insert into @GUIDUnsGroupB02(UID_SingleGuid) select g.UID_UNSGroupB2 from UNSGroupB2 g join inserted i on g.XObjectKey = i.ObjectKeyGroup if @@ROWCOUNT13 > 0 begin declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from14 ( select uig.UID_UNSAccountB as uid from UNSAccountBInUNSGroupB2 uig join @GUIDUnsGroupB02 gg on uig.UID_UNSGroupB2 = gg.UID_SingleGuid union select uig.UID_UNSAccountB15 as uid from UNSAccountBHasUNSGroupB2 uig join @GUIDUnsGroupB02 gg on uig.UID_UNSGroupB2 = gg.UID_SingleGuid ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB2'16, @DBQueueElements_02 end  declare @GUIDUnsGroupB03 QBM_YSingleGUID insert into @GUIDUnsGroupB03(UID_SingleGuid) select g.UID_UNSGroupB3 from UNSGroupB317 g join inserted i on g.XObjectKey = i.ObjectKeyGroup if @@ROWCOUNT > 0 begin declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_0318 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uig.UID_UNSAccountB as uid from UNSAccountBInUNSGroupB3 uig join @GUIDUnsGroupB0319 gg on uig.UID_UNSGroupB3 = gg.UID_SingleGuid union select uig.UID_UNSAccountB as uid from UNSAccountBHasUNSGroupB3 uig join @GUIDUnsGroupB03 gg on uig.UID_UNSGroupB320 = gg.UID_SingleGuid ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB3', @DBQueueElements_03 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd21 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 22