Back to OIM Explorer

dbo.ADS_ZPersonHasADSGroup

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 5; Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 5; Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 8; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 1.303 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 -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 5
  • Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 5
  • Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 8
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task ADS_ZAccountInADSGroup at line 5 Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 5
  • queues DBQueue task ADS_ZContactInADSGroup at line 5 Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 5
  • queues DBQueue task ADS_ZContactInADSGroup at line 8 Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 8
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task ADS-K-ADSAccountInADSGroup -> ADS_ZAccountInADSGroup QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select distinct a.u…
  • queues DBQueue task ADS-K-ADSContactInADSGroup -> ADS_ZContactInADSGroup QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_02 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18 , 1) WITH NOWAIT END CATCH endLabel: end

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL68 lines
1CREATE PROCEDURE ADS_ZPersonHasADSGroup(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent7  BEGIN TRY8    INSERT INTO @DBQueueCurrent(UID_DialogDBQueue,9    UID_Parameter,10    UID_SubParameter,11    GenProcID)12    SELECT13      UID_DialogDBQueue,14      UID_Parameter,15      UID_SubParameter,16      GenProcID17    FROM QBMDBQueueCurrent cu18      WITH(readpast)19    WHERE20      cu.SlotNumber = @SlotNumber21    IF @@rowcount = 022    BEGIN23      GOTO EndLabel24    END25    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw26    INSERT INTO @DBQueueElements_01(object,27    subobject,28    genprocid)29    SELECT30      x.uid,31      NULL,32      x.GenProcID33    FROM(34    SELECT35      DISTINCT a.uid_ADSAccount AS uid,36      p.GenProcID37    FROM @DBQueueCurrent p38    JOIN ADSAccount a39      ON a.uid_person = p.uid_Parameter AND a.UID_Person > ' ') AS x40    EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup',41      @DBQueueElements_0142    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw43    INSERT INTO @DBQueueElements_02(object,44    subobject,45    genprocid)46    SELECT47      x.uid,48      NULL,49      x.GenProcID50    FROM(51    SELECT52      DISTINCT a.uid_ADSContact AS uid,53      p.GenProcID54    FROM @DBQueueCurrent p55    JOIN ADSContact a56      ON a.uid_person = p.uid_Parameter AND a.UID_Person > ' ') AS x57    EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup',58      @DBQueueElements_0259  END TRY60  BEGIN CATCH61    EXEC QBM_PSessionErrorAdd DEFAULT62    RAISERROR('',63    18,64    1)65      WITH NOWAIT66  END CATCH67  endLabel:68END
Open raw exported source
SQL · Raw10 lines
1      create   procedure ADS_ZPersonHasADSGroup (@SlotNumber int) AS begin declare @DBQueueCurrent QBM_YDBQueueCurrent BEGIN TRY insert into @DBQueueCurrent2(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent3 cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end declare @DBQueueElements_01 QBM_YDBQueueRaw insert into4 @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select distinct a.uid_ADSAccount as uid, p.GenProcID from @DBQueueCurrent5 p join ADSAccount a on a.uid_person = p.uid_Parameter and a.UID_Person > ' ' ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup', @DBQueueElements_016 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select7 distinct a.uid_ADSContact as uid, p.GenProcID from @DBQueueCurrent p join ADSContact a on a.uid_person = p.uid_Parameter and a.UID_Person > ' ' ) as x8 exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_02 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 189, 1) WITH NOWAIT END CATCH endLabel: end 10