Back to OIM Explorer

dbo.TSB_TIUNSGroupB3Exclusion

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on UNSGroupB3Exclusion. Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 11; Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB3 / TSB_ZOrgHasUNSGroupB3 at line 11; Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB3 / TSB_ZOrgHasUNSGroupB3 at line 14; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 2.263 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 11
  • Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB3 / TSB_ZOrgHasUNSGroupB3 at line 11
  • Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB3 / TSB_ZOrgHasUNSGroupB3 at line 14
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: UNSGroupB3Exclusion

Typed Edges

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

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL96 lines
1CREATE trigger TSB_TIUNSGroupB3Exclusion2  ON UNSGroupB3Exclusion 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_UNSGroupB3Higher,26      UID_UNSGroupB3Lower27    FROM inserted28    EXEC QER_PExclusionCheckCircular @TargetTable = 'UNSGroupB3Exclusion',29      @HigherColumn = 'UID_UNSGroupB3Higher',30      @LowerColumn = 'UID_UNSGroupB3Lower',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_UNSGroupB3Lower AS UID_UNSGroupB344    FROM inserted45    UNION46    SELECT UID_UNSGroupB3Higher47    FROM inserted) AS y48    JOIN UNSGroupB3Collection coll49      ON y.uid_UNSGroupB3 = coll.UID_UNSGroupB3Parent50    JOIN UNSAccountBInUNSGroupB3 uig51      ON coll.UID_UNSGroupB3Child = uig.uid_UNSGroupB352    UNION53    SELECT uig.uid_unsaccountB AS uid54    FROM(55    SELECT UID_UNSGroupB3Lower AS UID_UNSGroupB356    FROM inserted57    UNION58    SELECT UID_UNSGroupB3Higher59    FROM inserted) AS y60    JOIN UNSGroupB3Collection coll61      ON y.uid_UNSGroupB3 = coll.UID_UNSGroupB3Parent62    JOIN UNSAccountBHasUNSGroupB3 uig63      ON coll.UID_UNSGroupB3Child = uig.uid_UNSGroupB3) AS x64    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB3',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_UNSGroupB3Lower AS UID_UNSGroupB378    FROM inserted79    UNION80    SELECT UID_UNSGroupB3Higher81    FROM inserted) AS y82    JOIN BaseTreeHasUNSGroupB3 g83      ON y.UID_UNSGroupB3 = g.UID_UNSGroupB3) AS x84    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-OrgHasUNSGroupB3',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_TIUNSGroupB3Exclusion on UNSGroupB3Exclusion  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_UNSGroupB3Higher, UID_UNSGroupB3Lower from inserted exec QER_PExclusionCheckCircular5 @TargetTable = 'UNSGroupB3Exclusion' , @HigherColumn = 'UID_UNSGroupB3Higher' , @LowerColumn = 'UID_UNSGroupB3Lower' , @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_UNSGroupB3Lower as UID_UNSGroupB3 from inserted union select UID_UNSGroupB3Higher from inserted ) as8 y  join UNSGroupB3Collection coll on y.uid_UNSGroupB3 = coll.UID_UNSGroupB3Parent join UNSAccountBInUNSGroupB3 uig on coll.UID_UNSGroupB3Child9 = uig.uid_UNSGroupB3   union select uig.uid_unsaccountB as uid from ( select UID_UNSGroupB3Lower as UID_UNSGroupB3 from inserted union select UID_UNSGroupB3Higher10 from inserted ) as y  join UNSGroupB3Collection coll on y.uid_UNSGroupB3 = coll.UID_UNSGroupB3Parent join UNSAccountBHasUNSGroupB3 uig on coll.UID_UNSGroupB3Child11 = uig.uid_UNSGroupB3   ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB3', @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_UNSGroupB3Lower13 as UID_UNSGroupB3 from inserted union select UID_UNSGroupB3Higher from inserted ) as y join BaseTreeHasUNSGroupB3 g on y.UID_UNSGroupB3 = g.UID_UNSGroupB314 ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-OrgHasUNSGroupB3', @DBQueueElements_02 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (''15, 18, 1) WITH NOWAIT END CATCH ende: return end 16