Back to OIM Explorer

dbo.LDP_TITSBSpecificGroupBehavior

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on TSBSpecificGroupBehavior. Bulk DBQueue insert -> LDP-K-LDAPAccountInLDAPGroup / LDP_ZAccountInLDAPGroup at line 6; References QBM_PDBQueueInsert_Bulk; Trigger parent table: TSBSpecificGroupBehavior

Source: sandbox-db sys.sql_modules

Source size: 1.015 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 -> LDP-K-LDAPAccountInLDAPGroup / LDP_ZAccountInLDAPGroup at line 6
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: TSBSpecificGroupBehavior

Typed Edges

  • queues DBQueue task LDP_ZAccountInLDAPGroup at line 6 Bulk DBQueue insert -> LDP-K-LDAPAccountInLDAPGroup / LDP_ZAccountInLDAPGroup at line 6
  • trigger on table TSBSpecificGroupBehavior Trigger parent table: TSBSpecificGroupBehavior
  • 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

Referenced By

  • No direct source references extracted.

Complete Source

SQL47 lines
1CREATE trigger LDP_TITSBSpecificGroupBehavior2  ON TSBSpecificGroupBehavior FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    RETURN start:13    DECLARE @GUIDLDAPGroup QBM_YSingleGUID14    INSERT INTO @GUIDLDAPGroup(UID_SingleGuid)15    SELECT g.UID_LDAPGroup16    FROM LDAPGroup g17    JOIN inserted i18      ON g.XObjectKey = i.ObjectKeyGroup19    IF @@ROWCOUNT > 020    BEGIN21      DECLARE @DBQueueElements_LDAPAccountInLDAPGroup QBM_YDBQueueRaw22      INSERT INTO @DBQueueElements_LDAPAccountInLDAPGroup(object,23      subobject,24      genprocid)25      SELECT26        x.uid,27        NULL,28        @GenProcID29      FROM(30      SELECT uig.UID_LDAPAccount AS uid31      FROM LDAPAccountInLDAPGroup uig32      JOIN @GUIDLDAPGroup gg33        ON uig.UID_LDAPGroup = gg.UID_SingleGuid) AS x34      EXEC QBM_PDBQueueInsert_Bulk 'LDP-K-LDAPAccountInLDAPGroup',35        @DBQueueElements_LDAPAccountInLDAPGroup36    END37  END TRY38  BEGIN CATCH39    EXEC QBM_PSessionErrorAdd DEFAULT40    RAISERROR('',41    18,42    1)43      WITH NOWAIT44  END CATCH45  EndLabel:46  RETURN47END
Open raw exported source
SQL ยท Raw8 lines
1 create   trigger LDP_TITSBSpecificGroupBehavior on TSBSpecificGroupBehavior  for insert not for Replication as begin declare @GenProcID varchar2(38) = dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from inserted) goto start return start: declare @GUIDLDAPGroup QBM_YSingleGUID3 insert into @GUIDLDAPGroup(UID_SingleGuid) select g.UID_LDAPGroup from LDAPGroup g join inserted i on g.XObjectKey = i.ObjectKeyGroup if @@ROWCOUNT > 40 begin declare @DBQueueElements_LDAPAccountInLDAPGroup QBM_YDBQueueRaw insert into @DBQueueElements_LDAPAccountInLDAPGroup (object, subobject, genprocid5) select x.uid, null, @GenProcID from ( select uig.UID_LDAPAccount as uid from LDAPAccountInLDAPGroup uig join @GUIDLDAPGroup gg on uig.UID_LDAPGroup =6 gg.UID_SingleGuid ) as x exec QBM_PDBQueueInsert_Bulk 'LDP-K-LDAPAccountInLDAPGroup', @DBQueueElements_LDAPAccountInLDAPGroup end  END TRY BEGIN CATCH7 exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH EndLabel: return end 8