Back to OIM Explorer

dbo.TSB_TIUNSGroupB3InUNSGroupB3

Database TriggerSQL_TRIGGERSandbox DB

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

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-UNSGroupB3InUNSGroupB3 / TSB_ZUNSGroupB3InUNSGroupB3 at line 11
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: UNSGroupB3InUNSGroupB3

Typed Edges

  • queues DBQueue task TSB_ZUNSGroupB3InUNSGroupB3 at line 11 Bulk DBQueue insert -> TSB-K-UNSGroupB3InUNSGroupB3 / TSB_ZUNSGroupB3InUNSGroupB3 at line 11
  • trigger on table UNSGroupB3InUNSGroupB3 Trigger parent table: UNSGroupB3InUNSGroupB3
  • 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_TIUNSGroupB3 source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL89 lines
1CREATE trigger TSB_TIUNSGroupB3InUNSGroupB32  ON UNSGroupB3InUNSGroupB3 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 UNSGroupB3 g16        ON i.UID_UNSGroupB3Child = g.UID_UNSGroupB317      JOIN UNSGroupB3 u18        ON i.UID_UNSGroupB3Parent = u.UID_UNSGroupB319      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_UNSGroupB3Parent AS uid53    FROM inserted54    UNION55    SELECT UID_UNSGroupB3Child56    FROM inserted57    UNION58    SELECT co.uid_UNSGroupB3Parent AS uid59    FROM inserted i60    JOIN UNSGroupB3collection co61      ON i.UID_UNSGroupB3Child = co.UID_UNSGroupB3Child62    UNION63    SELECT co.uid_UNSGroupB3Parent64    FROM inserted i65    JOIN UNSGroupB3collection co66      ON i.UID_UNSGroupB3Parent = co.UID_UNSGroupB3Child67    UNION68    SELECT co.UID_UNSGroupB3Child69    FROM inserted i70    JOIN UNSGroupB3collection co71      ON i.UID_UNSGroupB3Child = co.UID_UNSGroupB3Parent72    UNION73    SELECT co.UID_UNSGroupB3Child74    FROM inserted i75    JOIN UNSGroupB3collection co76      ON i.UID_UNSGroupB3Parent = co.UID_UNSGroupB3Parent) AS x77    EXEC QBM_PDBQueueInsert_Bulk 'TSB-K-UNSGroupB3InUNSGroupB3',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_TIUNSGroupB3InUNSGroupB3 on UNSGroupB3InUNSGroupB3  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 UNSGroupB3 g on i.UID_UNSGroupB3Child = g.UID_UNSGroupB33 join UNSGroupB3 u on i.UID_UNSGroupB3Parent = u.UID_UNSGroupB3 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_UNSGroupB3Parent as uid from inserted8 union select UID_UNSGroupB3Child from inserted union  select co.uid_UNSGroupB3Parent as uid from inserted i join UNSGroupB3collection co on i.UID_UNSGroupB3Child9 = co.UID_UNSGroupB3Child  union select co.uid_UNSGroupB3Parent from inserted i join UNSGroupB3collection co on i.UID_UNSGroupB3Parent = co.UID_UNSGroupB3Child10  union select co.UID_UNSGroupB3Child from inserted i join UNSGroupB3collection co on i.UID_UNSGroupB3Child = co.UID_UNSGroupB3Parent  union select11 co.UID_UNSGroupB3Child from inserted i join UNSGroupB3collection co on i.UID_UNSGroupB3Parent = co.UID_UNSGroupB3Parent ) as x exec QBM_PDBQueueInsert_Bulk12 'TSB-K-UNSGroupB3InUNSGroupB3', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH13 ende: return end 14