Back to OIM Explorer

dbo.ADS_ZAllForOneHardware

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> ADS-K-ADSMachineInADSGroup / ADS_ZADSMachineInADSGroup at line 3; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 651 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-ADSMachineInADSGroup / ADS_ZADSMachineInADSGroup at line 3
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

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

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL35 lines
1CREATE PROCEDURE ADS_ZAllForOneHardware(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      m.uid_ADSMachine AS uid,18      x.GenProcID19    FROM QBMDBQueueCurrent x20      WITH(readpast)21    JOIN Hardware h22      ON x.uid_parameter = h.uid_Hardware AND x.SlotNumber = @SlotNumber23    JOIN ADSMachine m24      ON m.uid_Hardware = h.uid_Hardware) AS x25    EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup',26      @DBQueueElements_0127  END TRY28  BEGIN CATCH29    EXEC QBM_PSessionErrorAdd DEFAULT30    RAISERROR('',31    18,32    1)33      WITH NOWAIT34  END CATCH35END
Open raw exported source
SQL ยท Raw6 lines
1       create   procedure ADS_ZAllForOneHardware (@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 m.uid_ADSMachine as uid, x.GenProcID from QBMDBQueueCurrent x with (readpast3) join Hardware h on x.uid_parameter = h.uid_Hardware and x.SlotNumber = @SlotNumber join ADSMachine m on m.uid_Hardware = h.uid_Hardware ) as x exec QBM_PDBQueueInsert_Bulk4 'ADS-K-ADSMachineInADSGroup', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end5 6