Back to OIM Explorer

dbo.QBM_ZRITriggerCreate

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> QBM-K-CommonMakeRITriggerI / QBM_ZRITriggerCreateI at line 3; Bulk DBQueue insert -> QBM-K-CommonMakeRITriggerU / QBM_ZRITriggerCreateU at line 3; Bulk DBQueue insert -> QBM-K-CommonMakeRITriggerD / QBM_ZRITriggerCreateD at line 3; Bulk DBQueue insert -> QBM-K-CommonMakeRITriggerD / QBM_ZRITriggerCreateD at line 4

Source: sandbox-db sys.sql_modules

Source size: 703 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 -> QBM-K-CommonMakeRITriggerI / QBM_ZRITriggerCreateI at line 3
  • Bulk DBQueue insert -> QBM-K-CommonMakeRITriggerU / QBM_ZRITriggerCreateU at line 3
  • Bulk DBQueue insert -> QBM-K-CommonMakeRITriggerD / QBM_ZRITriggerCreateD at line 3
  • Bulk DBQueue insert -> QBM-K-CommonMakeRITriggerD / QBM_ZRITriggerCreateD at line 4
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task QBM_ZRITriggerCreateI at line 3 Bulk DBQueue insert -> QBM-K-CommonMakeRITriggerI / QBM_ZRITriggerCreateI at line 3
  • queues DBQueue task QBM_ZRITriggerCreateU at line 3 Bulk DBQueue insert -> QBM-K-CommonMakeRITriggerU / QBM_ZRITriggerCreateU at line 3
  • queues DBQueue task QBM_ZRITriggerCreateD at line 3 Bulk DBQueue insert -> QBM-K-CommonMakeRITriggerD / QBM_ZRITriggerCreateD at line 3
  • queues DBQueue task QBM_ZRITriggerCreateD at line 4 Bulk DBQueue insert -> QBM-K-CommonMakeRITriggerD / QBM_ZRITriggerCreateD at line 4
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task QBM-K-CommonMakeRITriggerI -> QBM_ZRITriggerCreateI QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITriggerI', @DBQueueElements_01 exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITriggerU' , @DBQueueElements_01 exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITriggerD', @DBQueueElements_01 END TR…
  • queues DBQueue task QBM-K-CommonMakeRITriggerU -> QBM_ZRITriggerCreateU QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITriggerU' , @DBQueueElements_01 exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITriggerD', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWA…
  • queues DBQueue task QBM-K-CommonMakeRITriggerD -> QBM_ZRITriggerCreateD QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITriggerD', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

References

Referenced By

Complete Source

SQL36 lines
1CREATE PROCEDURE QBM_ZRITriggerCreate(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @DebugLevel char(1) = 'W'7  BEGIN TRY8    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw9    INSERT INTO @DBQueueElements_01(Object,10    SubObject,11    GenProcID)12    SELECT13      cu.UID_Parameter,14      NULL,15      cu.GenProcID16    FROM QBMDBQueueCurrent cu17      WITH(readpast)18    WHERE19      cu.SlotNumber = @SlotNumber20    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITriggerI',21      @DBQueueElements_0122    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITriggerU',23      @DBQueueElements_0124    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITriggerD',25      @DBQueueElements_0126  END TRY27  BEGIN CATCH28    EXEC QBM_PSessionErrorAdd DEFAULT29    RAISERROR('',30    18,31    1)32      WITH NOWAIT33  END CATCH34  ende:35  RETURN36END
Open raw exported source
SQL · Raw6 lines
1  create   procedure QBM_ZRITriggerCreate (@SlotNumber int ) as begin declare @DebugLevel char(1) = 'W' BEGIN TRY declare @DBQueueElements_01 QBM_YDBQueueRaw2 insert into @DBQueueElements_01(Object, SubObject, GenProcID) select cu.UID_Parameter, null, cu.GenProcID from QBMDBQueueCurrent cu with (readpast) where3 cu.SlotNumber = @SlotNumber exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITriggerI', @DBQueueElements_01 exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITriggerU'4, @DBQueueElements_01 exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonMakeRITriggerD', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default5 RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  ende: return end 6