Back to OIM Explorer

dbo.TSB_TIUNSGroupBExclusion

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on UNSGroupBExclusion. Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB / TSB_ZUNSAccountBInUNSGroupB at line 11; Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB / TSB_ZOrgHasUNSGroupB at line 11; Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB / TSB_ZOrgHasUNSGroupB at line 14; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 2.230 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 11
  • Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB / TSB_ZOrgHasUNSGroupB at line 11
  • Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB / TSB_ZOrgHasUNSGroupB at line 14
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: UNSGroupBExclusion

Typed Edges

  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB at line 11 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB / TSB_ZUNSAccountBInUNSGroupB at line 11
  • queues DBQueue task TSB_ZOrgHasUNSGroupB at line 11 Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB / TSB_ZOrgHasUNSGroupB at line 11
  • queues DBQueue task TSB_ZOrgHasUNSGroupB at line 14 Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB / TSB_ZOrgHasUNSGroupB at line 14
  • trigger on table UNSGroupBExclusion Trigger parent table: UNSGroupBExclusion
  • references source dbo.QBM_FGIConfigparmValue source text reference
  • 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.QER_PExclusionCheckCircular source text reference
  • references source dbo.TSB_TIUNSGroupB source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL96 lines
1CREATE trigger TSB_TIUNSGroupBExclusion2  ON UNSGroupBExclusion FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @exclusions QBM_YParameterList7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    RETURN start:13    DECLARE @GenProcID varchar(38)14    SELECT @GenProcID = dbo.QBM_FGISessionContext('')15    IF dbo.QBM_FGIConfigparmValue('QER\Structures\Inherite\GroupExclusion') = ''16    BEGIN17      RAISERROR('#LDS#Cannot make a definition because exclusion is not enabled by config parm.|',18      18,19      2)20        WITH nowait21    END22    INSERT INTO @exclusions(Parameter1,23    Parameter2)24    SELECT25      UID_UNSGroupBHigher,26      UID_UNSGroupBLower27    FROM inserted28    EXEC QER_PExclusionCheckCircular @TargetTable = 'UNSGroupBExclusion',29      @HigherColumn = 'UID_UNSGroupBHigher',30      @LowerColumn = 'UID_UNSGroupBLower',31      @exclusions = @exclusions32    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw33    INSERT INTO @DBQueueElements_01(object,34    subobject,35    genprocid)36    SELECT37      x.uid,38      NULL,39      @GenProcID40    FROM(41    SELECT uig.uid_unsaccountB AS uid42    FROM(43    SELECT UID_UNSGroupBLower AS UID_UNSGroupB44    FROM inserted45    UNION46    SELECT UID_UNSGroupBHigher47    FROM inserted) AS y48    JOIN UNSGroupBCollection coll49      ON y.uid_UNSGroupB = coll.UID_UNSGroupBParent50    JOIN UNSAccountBInUNSGroupB uig51      ON coll.UID_UNSGroupBChild = uig.uid_UNSGroupB52    UNION53    SELECT uig.uid_unsaccountB AS uid54    FROM(55    SELECT UID_UNSGroupBLower AS UID_UNSGroupB56    FROM inserted57    UNION58    SELECT UID_UNSGroupBHigher59    FROM inserted) AS y60    JOIN UNSGroupBCollection coll61      ON y.uid_UNSGroupB = coll.UID_UNSGroupBParent62    JOIN UNSAccountBHasUNSGroupB uig63      ON coll.UID_UNSGroupBChild = uig.uid_UNSGroupB) AS x64    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB',65      @DBQueueElements_0166    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw67    INSERT INTO @DBQueueElements_02(object,68    subobject,69    genprocid)70    SELECT71      x.uid,72      NULL,73      @GenProcID74    FROM(75    SELECT g.UID_Org AS uid76    FROM(77    SELECT UID_UNSGroupBLower AS UID_UNSGroupB78    FROM inserted79    UNION80    SELECT UID_UNSGroupBHigher81    FROM inserted) AS y82    JOIN BaseTreeHasUNSGroupB g83      ON y.UID_UNSGroupB = g.UID_UNSGroupB) AS x84    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-OrgHasUNSGroupB',85      @DBQueueElements_0286  END TRY87  BEGIN CATCH88    EXEC QBM_PSessionErrorAdd DEFAULT89    RAISERROR('',90    18,91    1)92      WITH NOWAIT93  END CATCH94  ende:95  RETURN96END
Open raw exported source
SQL ยท Raw16 lines
1    create   trigger TSB_TIUNSGroupBExclusion on UNSGroupBExclusion  for Insert not for Replication as begin  declare @exclusions QBM_YParameterList2 BEGIN TRY if exists (select top 1 1 from inserted) goto start return start:  declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext3('') if dbo.QBM_FGIConfigparmValue('QER\Structures\Inherite\GroupExclusion') = '' begin raiserror( '#LDS#Cannot make a definition because exclusion is not enabled by config parm.|'4, 18, 2) with nowait end insert into @exclusions (Parameter1, Parameter2) select UID_UNSGroupBHigher, UID_UNSGroupBLower from inserted exec QER_PExclusionCheckCircular5 @TargetTable = 'UNSGroupBExclusion' , @HigherColumn = 'UID_UNSGroupBHigher' , @LowerColumn = 'UID_UNSGroupBLower' , @exclusions = @exclusions6 declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select7 uig.uid_unsaccountB as uid from ( select UID_UNSGroupBLower as UID_UNSGroupB from inserted union select UID_UNSGroupBHigher from inserted ) as8 y  join UNSGroupBCollection coll on y.uid_UNSGroupB = coll.UID_UNSGroupBParent join UNSAccountBInUNSGroupB uig on coll.UID_UNSGroupBChild9 = uig.uid_UNSGroupB   union select uig.uid_unsaccountB as uid from ( select UID_UNSGroupBLower as UID_UNSGroupB from inserted union select UID_UNSGroupBHigher10 from inserted ) as y  join UNSGroupBCollection coll on y.uid_UNSGroupB = coll.UID_UNSGroupBParent join UNSAccountBHasUNSGroupB uig on coll.UID_UNSGroupBChild11 = uig.uid_UNSGroupB   ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw12 insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select g.UID_Org as uid from ( select UID_UNSGroupBLower13 as UID_UNSGroupB from inserted union select UID_UNSGroupBHigher from inserted ) as y join BaseTreeHasUNSGroupB g on y.UID_UNSGroupB = g.UID_UNSGroupB14 ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-OrgHasUNSGroupB', @DBQueueElements_02 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (''15, 18, 1) WITH NOWAIT END CATCH ende: return end 16