Back to OIM Explorer

dbo.LDP_ZPersonHasLDAPGroup

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> LDP-K-LDAPAccountInLDAPGroup / LDP_ZAccountInLDAPGroup at line 3; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 638 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • 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 3
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task LDP_ZAccountInLDAPGroup at line 3 Bulk DBQueue insert -> LDP-K-LDAPAccountInLDAPGroup / LDP_ZAccountInLDAPGroup at line 3
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task LDP-K-LDAPAccountInLDAPGroup -> LDP_ZAccountInLDAPGroup QBM_PDBQueueInsert_Bulk 'LDP-K-LDAPAccountInLDAPGroup', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: end

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL34 lines
1CREATE PROCEDURE LDP_ZPersonHasLDAPGroup(2  @SlotNumber int3)4AS5BEGIN6  BEGIN TRY7    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw8    INSERT INTO @DBQueueElements_01(object,9    subobject,10    genprocid)11    SELECT12      x.uid,13      NULL,14      x.GenProcID15    FROM(16    SELECT17      DISTINCT a.uid_LDAPAccount AS uid,18      p.GenProcID19    FROM QBMDBQueueCurrent p20      WITH(readpast)21    JOIN LDAPAccount a22      ON a.uid_person = p.uid_Parameter AND p.SlotNumber = @SlotNumber AND a.UID_Person > ' ') AS x23    EXEC QBM_PDBQueueInsert_Bulk 'LDP-K-LDAPAccountInLDAPGroup',24      @DBQueueElements_0125  END TRY26  BEGIN CATCH27    EXEC QBM_PSessionErrorAdd DEFAULT28    RAISERROR('',29    18,30    1)31      WITH NOWAIT32  END CATCH33  ende:34END
Open raw exported source
SQL ยท Raw6 lines
1    create   procedure LDP_ZPersonHasLDAPGroup (@SlotNumber int) AS begin BEGIN TRY declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_012 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select distinct a.uid_LDAPAccount as uid, p.GenProcID from QBMDBQueueCurrent p with3 (readpast) join LDAPAccount a on a.uid_person = p.uid_Parameter and p.SlotNumber = @SlotNumber and a.UID_Person > ' ' ) as x exec QBM_PDBQueueInsert_Bulk4 'LDP-K-LDAPAccountInLDAPGroup', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH 5ende: end 6