Back to OIM Explorer

dbo.LDP_TILDAPGroup

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on LDAPGroup. Bulk DBQueue insert -> LDP-K-LDAPGroupInLDAPGroup / LDP_ZGroupInLDAPGroup at line 4; References QBM_PDBQueueInsert_Bulk; Trigger parent table: LDAPGroup

Source: sandbox-db sys.sql_modules

Source size: 668 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-LDAPGroupInLDAPGroup / LDP_ZGroupInLDAPGroup at line 4
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: LDAPGroup

Typed Edges

  • queues DBQueue task LDP_ZGroupInLDAPGroup at line 4 Bulk DBQueue insert -> LDP-K-LDAPGroupInLDAPGroup / LDP_ZGroupInLDAPGroup at line 4
  • trigger on table LDAPGroup Trigger parent table: LDAPGroup
  • 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

Complete Source

SQL38 lines
1CREATE trigger LDP_TILDAPGroup2  ON LDAPGroup FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @errno int7  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    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw16    INSERT INTO @DBQueueElements_01(object,17    subobject,18    genprocid)19    SELECT20      x.uid,21      NULL,22      @GenProcID23    FROM(24    SELECT uid_LDAPGroup AS uid25    FROM inserted) AS x26    EXEC QBM_PDBQueueInsert_Bulk 'LDP-K-LDAPGroupInLDAPGroup',27      @DBQueueElements_0128  END TRY29  BEGIN CATCH30    EXEC QBM_PSessionErrorAdd DEFAULT31    RAISERROR('',32    18,33    1)34      WITH NOWAIT35  END CATCH36  ende:37  RETURN38END
Open raw exported source
SQL ยท Raw6 lines
1    create   trigger LDP_TILDAPGroup on LDAPGroup  for Insert not for Replication as begin  declare @errno int BEGIN TRY if exists (select top 12 1 from inserted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') declare @DBQueueElements_013 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uid_LDAPGroup as uid from 4inserted ) as x exec QBM_PDBQueueInsert_Bulk 'LDP-K-LDAPGroupInLDAPGroup', @DBQueueElements_01   END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default 5RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 6