Back to OIM Explorer

dbo.TSB_TIUNSAccountB

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on UNSAccountB. Bulk DBQueue insert -> TSB-K-PersonHasObject / TSB_ZPersonHasObject at line 4; Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB / TSB_ZUNSAccountBInUNSGroupB at line 4; Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 4; Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 4

Source: sandbox-db sys.sql_modules

Source size: 2.238 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 4
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB / TSB_ZUNSAccountBInUNSGroupB at line 4
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 4
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 4
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 4
  • 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 9
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 9
  • Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 9
  • 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-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 14
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: UNSAccountB

Typed Edges

  • queues DBQueue task TSB_ZPersonHasObject at line 4 Bulk DBQueue insert -> TSB-K-PersonHasObject / TSB_ZPersonHasObject at line 4
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB at line 4 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB / TSB_ZUNSAccountBInUNSGroupB at line 4
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB1 at line 4 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 4
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB2 at line 4 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 4
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB3 at line 4 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 4
  • 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 9 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 9
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB2 at line 9 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 9
  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB3 at line 9 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 9
  • 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_ZUNSAccountBInUNSGroupB3 at line 14 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 14
  • trigger on table UNSAccountB Trigger parent table: UNSAccountB
  • 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

Complete Source

SQL107 lines
1CREATE trigger TSB_TIUNSAccountB2  ON UNSAccountB FOR3INSERT NOT FOR Replication4AS5BEGIN6  IF EXISTS(7    SELECT TOP 1 18    FROM inserted)9  GOTO start10  RETURN start:11  DECLARE @GenProcID varchar(38)12  BEGIN TRY13    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    SELECT24      DISTINCT uid_person AS uid25    FROM inserted26    WHERE27      uid_person > ' ') AS x28    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-PersonHasObject',29      @DBQueueElements_0130    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw31    INSERT INTO @DBQueueElements_02(object,32    subobject,33    genprocid)34    SELECT35      x.uid,36      NULL,37      @GenProcID38    FROM(39    SELECT i.UID_UNSAccountB AS uid40    FROM inserted i41    JOIN UNSRootB r42      ON i.UID_UNSRootB = r.UID_UNSRootB43    WHERE44      r.GroupUsageMask & 0x01 > 0 AND uid_person > ' ') AS x45    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB',46      @DBQueueElements_0247    DECLARE @DBQueueElements_03 QBM_YDBQueueRaw48    INSERT INTO @DBQueueElements_03(object,49    subobject,50    genprocid)51    SELECT52      x.uid,53      NULL,54      @GenProcID55    FROM(56    SELECT i.UID_UNSAccountB AS uid57    FROM inserted i58    JOIN UNSRootB r59      ON i.UID_UNSRootB = r.UID_UNSRootB60    WHERE61      r.GroupUsageMask & 0x02 > 0 AND uid_person > ' ') AS x62    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB1',63      @DBQueueElements_0364    DECLARE @DBQueueElements_04 QBM_YDBQueueRaw65    INSERT INTO @DBQueueElements_04(object,66    subobject,67    genprocid)68    SELECT69      x.uid,70      NULL,71      @GenProcID72    FROM(73    SELECT i.UID_UNSAccountB AS uid74    FROM inserted i75    JOIN UNSRootB r76      ON i.UID_UNSRootB = r.UID_UNSRootB77    WHERE78      r.GroupUsageMask & 0x04 > 0 AND uid_person > ' ') AS x79    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB2',80      @DBQueueElements_0481    DECLARE @DBQueueElements_05 QBM_YDBQueueRaw82    INSERT INTO @DBQueueElements_05(object,83    subobject,84    genprocid)85    SELECT86      x.uid,87      NULL,88      @GenProcID89    FROM(90    SELECT i.UID_UNSAccountB AS uid91    FROM inserted i92    JOIN UNSRootB r93      ON i.UID_UNSRootB = r.UID_UNSRootB94    WHERE95      r.GroupUsageMask & 0x08 > 0 AND uid_person > ' ') AS x96    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB3',97      @DBQueueElements_0598  END TRY99  BEGIN CATCH100    EXEC QBM_PSessionErrorAdd DEFAULT101    RAISERROR('',102    18,103    1)104      WITH NOWAIT105  END CATCH106  RETURN107END
Open raw exported source
SQL ยท Raw16 lines
1    create   trigger TSB_TIUNSAccountB on UNSAccountB  for Insert not for Replication as begin  if exists (select top 1 1 from inserted) goto start2 return start: declare @GenProcID varchar(38) BEGIN TRY select @GenProcID = dbo.QBM_FGISessionContext('')  declare @DBQueueElements_01 QBM_YDBQueueRaw 3insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct uid_person as uid from inserted where4 uid_person > ' ' ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-PersonHasObject', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into5 @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select i.UID_UNSAccountB as uid from inserted i join UNSRootB 6r on i.UID_UNSRootB = r.UID_UNSRootB where r.GroupUsageMask & 0x01 > 0 and uid_person > ' ' ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB'7, @DBQueueElements_02 declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID8 from (select i.UID_UNSAccountB as uid from inserted i join UNSRootB r on i.UID_UNSRootB = r.UID_UNSRootB where r.GroupUsageMask & 0x02 > 0 and uid_person9 > ' ' ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB1', @DBQueueElements_03 declare @DBQueueElements_04 QBM_YDBQueueRaw insert into10 @DBQueueElements_04 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select i.UID_UNSAccountB as uid from inserted i join UNSRootB 11r on i.UID_UNSRootB = r.UID_UNSRootB where r.GroupUsageMask & 0x04 > 0 and uid_person > ' ' ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB2'12, @DBQueueElements_04 declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05 (object, subobject, genprocid) select x.uid, null, @GenProcID13 from (select i.UID_UNSAccountB as uid from inserted i join UNSRootB r on i.UID_UNSRootB = r.UID_UNSRootB where r.GroupUsageMask & 0x08 > 0 and uid_person14 > ' ' ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB3', @DBQueueElements_05  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default 15RAISERROR ('', 18, 1) WITH NOWAIT END CATCH return end 16