Back to OIM Explorer

dbo.TSB_TIUNSGroupB2Exclusion

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on UNSGroupB2Exclusion. Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 11; Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB2 / TSB_ZOrgHasUNSGroupB2 at line 11; Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB2 / TSB_ZOrgHasUNSGroupB2 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-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 11
  • Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB2 / TSB_ZOrgHasUNSGroupB2 at line 11
  • Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB2 / TSB_ZOrgHasUNSGroupB2 at line 14
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: UNSGroupB2Exclusion

Typed Edges

  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB2 at line 11 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 11
  • queues DBQueue task TSB_ZOrgHasUNSGroupB2 at line 11 Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB2 / TSB_ZOrgHasUNSGroupB2 at line 11
  • queues DBQueue task TSB_ZOrgHasUNSGroupB2 at line 14 Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB2 / TSB_ZOrgHasUNSGroupB2 at line 14
  • trigger on table UNSGroupB2Exclusion Trigger parent table: UNSGroupB2Exclusion
  • 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_TIUNSGroupB2 source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL96 lines
1CREATE trigger TSB_TIUNSGroupB2Exclusion2  ON UNSGroupB2Exclusion 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_UNSGroupB2Higher,26      UID_UNSGroupB2Lower27    FROM inserted28    EXEC QER_PExclusionCheckCircular @TargetTable = 'UNSGroupB2Exclusion',29      @HigherColumn = 'UID_UNSGroupB2Higher',30      @LowerColumn = 'UID_UNSGroupB2Lower',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_UNSGroupB2Lower AS UID_UNSGroupB244    FROM inserted45    UNION46    SELECT UID_UNSGroupB2Higher47    FROM inserted) AS y48    JOIN UNSGroupB2Collection coll49      ON y.uid_UNSGroupB2 = coll.UID_UNSGroupB2Parent50    JOIN UNSAccountBInUNSGroupB2 uig51      ON coll.UID_UNSGroupB2Child = uig.uid_UNSGroupB252    UNION53    SELECT uig.uid_unsaccountB AS uid54    FROM(55    SELECT UID_UNSGroupB2Lower AS UID_UNSGroupB256    FROM inserted57    UNION58    SELECT UID_UNSGroupB2Higher59    FROM inserted) AS y60    JOIN UNSGroupB2Collection coll61      ON y.uid_UNSGroupB2 = coll.UID_UNSGroupB2Parent62    JOIN UNSAccountBHasUNSGroupB2 uig63      ON coll.UID_UNSGroupB2Child = uig.uid_UNSGroupB2) AS x64    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB2',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_UNSGroupB2Lower AS UID_UNSGroupB278    FROM inserted79    UNION80    SELECT UID_UNSGroupB2Higher81    FROM inserted) AS y82    JOIN BaseTreeHasUNSGroupB2 g83      ON y.UID_UNSGroupB2 = g.UID_UNSGroupB2) AS x84    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-OrgHasUNSGroupB2',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_TIUNSGroupB2Exclusion on UNSGroupB2Exclusion  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_UNSGroupB2Higher, UID_UNSGroupB2Lower from inserted exec QER_PExclusionCheckCircular5 @TargetTable = 'UNSGroupB2Exclusion' , @HigherColumn = 'UID_UNSGroupB2Higher' , @LowerColumn = 'UID_UNSGroupB2Lower' , @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_UNSGroupB2Lower as UID_UNSGroupB2 from inserted union select UID_UNSGroupB2Higher from inserted ) as8 y  join UNSGroupB2Collection coll on y.uid_UNSGroupB2 = coll.UID_UNSGroupB2Parent join UNSAccountBInUNSGroupB2 uig on coll.UID_UNSGroupB2Child9 = uig.uid_UNSGroupB2   union select uig.uid_unsaccountB as uid from ( select UID_UNSGroupB2Lower as UID_UNSGroupB2 from inserted union select UID_UNSGroupB2Higher10 from inserted ) as y  join UNSGroupB2Collection coll on y.uid_UNSGroupB2 = coll.UID_UNSGroupB2Parent join UNSAccountBHasUNSGroupB2 uig on coll.UID_UNSGroupB2Child11 = uig.uid_UNSGroupB2   ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB2', @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_UNSGroupB2Lower13 as UID_UNSGroupB2 from inserted union select UID_UNSGroupB2Higher from inserted ) as y join BaseTreeHasUNSGroupB2 g on y.UID_UNSGroupB2 = g.UID_UNSGroupB214 ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-OrgHasUNSGroupB2', @DBQueueElements_02 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (''15, 18, 1) WITH NOWAIT END CATCH ende: return end 16