Back to OIM Explorer

dbo.TSB_TIUNSGroupB1Exclusion

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on UNSGroupB1Exclusion. Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 11; Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB1 / TSB_ZOrgHasUNSGroupB1 at line 11; Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB1 / TSB_ZOrgHasUNSGroupB1 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-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 11
  • Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB1 / TSB_ZOrgHasUNSGroupB1 at line 11
  • Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB1 / TSB_ZOrgHasUNSGroupB1 at line 14
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: UNSGroupB1Exclusion

Typed Edges

  • queues DBQueue task TSB_ZUNSAccountBInUNSGroupB1 at line 11 Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 11
  • queues DBQueue task TSB_ZOrgHasUNSGroupB1 at line 11 Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB1 / TSB_ZOrgHasUNSGroupB1 at line 11
  • queues DBQueue task TSB_ZOrgHasUNSGroupB1 at line 14 Bulk DBQueue insert -> TSB-K-OrgHasUNSGroupB1 / TSB_ZOrgHasUNSGroupB1 at line 14
  • trigger on table UNSGroupB1Exclusion Trigger parent table: UNSGroupB1Exclusion
  • 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_TIUNSGroupB1 source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL96 lines
1CREATE trigger TSB_TIUNSGroupB1Exclusion2  ON UNSGroupB1Exclusion 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_UNSGroupB1Higher,26      UID_UNSGroupB1Lower27    FROM inserted28    EXEC QER_PExclusionCheckCircular @TargetTable = 'UNSGroupB1Exclusion',29      @HigherColumn = 'UID_UNSGroupB1Higher',30      @LowerColumn = 'UID_UNSGroupB1Lower',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_UNSGroupB1Lower AS UID_UNSGroupB144    FROM inserted45    UNION46    SELECT UID_UNSGroupB1Higher47    FROM inserted) AS y48    JOIN UNSGroupB1Collection coll49      ON y.uid_UNSGroupB1 = coll.UID_UNSGroupB1Parent50    JOIN UNSAccountBInUNSGroupB1 uig51      ON coll.UID_UNSGroupB1Child = uig.uid_UNSGroupB152    UNION53    SELECT uig.uid_unsaccountB AS uid54    FROM(55    SELECT UID_UNSGroupB1Lower AS UID_UNSGroupB156    FROM inserted57    UNION58    SELECT UID_UNSGroupB1Higher59    FROM inserted) AS y60    JOIN UNSGroupB1Collection coll61      ON y.uid_UNSGroupB1 = coll.UID_UNSGroupB1Parent62    JOIN UNSAccountBHasUNSGroupB1 uig63      ON coll.UID_UNSGroupB1Child = uig.uid_UNSGroupB1) AS x64    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB1',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_UNSGroupB1Lower AS UID_UNSGroupB178    FROM inserted79    UNION80    SELECT UID_UNSGroupB1Higher81    FROM inserted) AS y82    JOIN BaseTreeHasUNSGroupB1 g83      ON y.UID_UNSGroupB1 = g.UID_UNSGroupB1) AS x84    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-OrgHasUNSGroupB1',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_TIUNSGroupB1Exclusion on UNSGroupB1Exclusion  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_UNSGroupB1Higher, UID_UNSGroupB1Lower from inserted exec QER_PExclusionCheckCircular5 @TargetTable = 'UNSGroupB1Exclusion' , @HigherColumn = 'UID_UNSGroupB1Higher' , @LowerColumn = 'UID_UNSGroupB1Lower' , @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_UNSGroupB1Lower as UID_UNSGroupB1 from inserted union select UID_UNSGroupB1Higher from inserted ) as8 y  join UNSGroupB1Collection coll on y.uid_UNSGroupB1 = coll.UID_UNSGroupB1Parent join UNSAccountBInUNSGroupB1 uig on coll.UID_UNSGroupB1Child9 = uig.uid_UNSGroupB1   union select uig.uid_unsaccountB as uid from ( select UID_UNSGroupB1Lower as UID_UNSGroupB1 from inserted union select UID_UNSGroupB1Higher10 from inserted ) as y  join UNSGroupB1Collection coll on y.uid_UNSGroupB1 = coll.UID_UNSGroupB1Parent join UNSAccountBHasUNSGroupB1 uig on coll.UID_UNSGroupB1Child11 = uig.uid_UNSGroupB1   ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-UNSAccountBInUNSGroupB1', @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_UNSGroupB1Lower13 as UID_UNSGroupB1 from inserted union select UID_UNSGroupB1Higher from inserted ) as y join BaseTreeHasUNSGroupB1 g on y.UID_UNSGroupB1 = g.UID_UNSGroupB114 ) as x exec QBM_PDBQueueInsert_Bulk 'TSB-K-OrgHasUNSGroupB1', @DBQueueElements_02 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (''15, 18, 1) WITH NOWAIT END CATCH ende: return end 16