Back to OIM Explorer

dbo.TSB_TIUNSGroupB2InUNSGroupB2

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on UNSGroupB2InUNSGroupB2. Bulk DBQueue insert -> TSB-K-UNSGroupB2InUNSGroupB2 / TSB_ZUNSGroupB2InUNSGroupB2 at line 11; References QBM_PDBQueueInsert_Bulk; Trigger parent table: UNSGroupB2InUNSGroupB2

Source: sandbox-db sys.sql_modules

Source size: 1.949 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-UNSGroupB2InUNSGroupB2 / TSB_ZUNSGroupB2InUNSGroupB2 at line 11
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: UNSGroupB2InUNSGroupB2

Typed Edges

  • queues DBQueue task TSB_ZUNSGroupB2InUNSGroupB2 at line 11 Bulk DBQueue insert -> TSB-K-UNSGroupB2InUNSGroupB2 / TSB_ZUNSGroupB2InUNSGroupB2 at line 11
  • trigger on table UNSGroupB2InUNSGroupB2 Trigger parent table: UNSGroupB2InUNSGroupB2
  • 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.TSB_TIUNSGroupB source text reference
  • references source dbo.TSB_TIUNSGroupB2 source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL89 lines
1CREATE trigger TSB_TIUNSGroupB2InUNSGroupB22  ON UNSGroupB2InUNSGroupB2 FOR3INSERT NOT FOR Replication4AS5BEGIN6  IF EXISTS(7    SELECT TOP 1 18    FROM inserted)9  GOTO start10  RETURN start:11  BEGIN TRY12    IF EXISTS(13      SELECT TOP 1 114      FROM inserted i15      JOIN UNSGroupB2 g16        ON i.UID_UNSGroupB2Child = g.UID_UNSGroupB217      JOIN UNSGroupB2 u18        ON i.UID_UNSGroupB2Parent = u.UID_UNSGroupB219      JOIN UNSRootB ru20        ON u.UID_UNSRootB = ru.UID_UNSRootB21      JOIN DPRNameSpace ns22        ON ru.UID_DPRNameSpace = ns.UID_DPRNameSpace23      JOIN UNSRootB rg24        ON g.UID_UNSRootB = rg.UID_UNSRootB25      WHERE26        0 = CASE27    WHEN u.UID_UNSRootB = g.UID_UNSRootB THEN28    129    WHEN ns.IsExtendedInheritance = 0 THEN30    031    WHEN ns.IsExtendedInheritance = 1 AND ns.UID_DPRNameSpace = rg.UID_DPRNameSpace THEN32    133    ELSE 034    END)35    BEGIN36      RAISERROR('#LDS#Assignment is not permitted due to the configuration of related UNSRoots.|',37      18,38      2)39        WITH nowait40    END41    DECLARE @GenProcID varchar(38)42    SELECT @GenProcID = dbo.QBM_FGISessionContext('')43    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw44    INSERT INTO @DBQueueElements_01(object,45    subobject,46    genprocid)47    SELECT48      x.uid,49      NULL,50      @GenProcID51    FROM(52    SELECT uid_UNSGroupB2Parent AS uid53    FROM inserted54    UNION55    SELECT UID_UNSGroupB2Child56    FROM inserted57    UNION58    SELECT co.uid_UNSGroupB2Parent AS uid59    FROM inserted i60    JOIN UNSGroupB2collection co61      ON i.UID_UNSGroupB2Child = co.UID_UNSGroupB2Child62    UNION63    SELECT co.uid_UNSGroupB2Parent64    FROM inserted i65    JOIN UNSGroupB2collection co66      ON i.UID_UNSGroupB2Parent = co.UID_UNSGroupB2Child67    UNION68    SELECT co.UID_UNSGroupB2Child69    FROM inserted i70    JOIN UNSGroupB2collection co71      ON i.UID_UNSGroupB2Child = co.UID_UNSGroupB2Parent72    UNION73    SELECT co.UID_UNSGroupB2Child74    FROM inserted i75    JOIN UNSGroupB2collection co76      ON i.UID_UNSGroupB2Parent = co.UID_UNSGroupB2Parent) AS x77    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSGroupB2InUNSGroupB2',78      @DBQueueElements_0179  END TRY80  BEGIN CATCH81    EXEC QBM_PSessionErrorAdd DEFAULT82    RAISERROR('',83    18,84    1)85      WITH NOWAIT86  END CATCH87  ende:88  RETURN89END
Open raw exported source
SQL ยท Raw14 lines
1  create   trigger TSB_TIUNSGroupB2InUNSGroupB2 on UNSGroupB2InUNSGroupB2  for Insert not for Replication as begin  if exists (select top2 1 1 from inserted) goto start return start: BEGIN TRY  if exists (select top 1 1 from inserted i join UNSGroupB2 g on i.UID_UNSGroupB2Child = g.UID_UNSGroupB23 join UNSGroupB2 u on i.UID_UNSGroupB2Parent = u.UID_UNSGroupB2 join UNSRootB ru on u.UID_UNSRootB = ru.UID_UNSRootB join DPRNameSpace ns on ru.UID_DPRNameSpace4 = ns.UID_DPRNameSpace join UNSRootB rg on g.UID_UNSRootB = rg.UID_UNSRootB where 0 = case when u.UID_UNSRootB = g.UID_UNSRootB then 1  when ns.IsExtendedInheritance5 = 0 then 0 when ns.IsExtendedInheritance = 1 and ns.UID_DPRNameSpace = rg.UID_DPRNameSpace then 1 else 0 end ) begin raiserror ('#LDS#Assignment is not permitted due to the configuration of related UNSRoots.|'6, 18, 2) with nowait end  declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') declare @DBQueueElements_01 QBM_YDBQueueRaw 7insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uid_UNSGroupB2Parent as uid from inserted8 union select UID_UNSGroupB2Child from inserted union  select co.uid_UNSGroupB2Parent as uid from inserted i join UNSGroupB2collection co on i.UID_UNSGroupB2Child9 = co.UID_UNSGroupB2Child  union select co.uid_UNSGroupB2Parent from inserted i join UNSGroupB2collection co on i.UID_UNSGroupB2Parent = co.UID_UNSGroupB2Child10  union select co.UID_UNSGroupB2Child from inserted i join UNSGroupB2collection co on i.UID_UNSGroupB2Child = co.UID_UNSGroupB2Parent  union select11 co.UID_UNSGroupB2Child from inserted i join UNSGroupB2collection co on i.UID_UNSGroupB2Parent = co.UID_UNSGroupB2Parent ) as x exec QBM_PDBQueueInsert_Bulk12 'TSB-K-UNSGroupB2InUNSGroupB2', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH13 ende: return end 14