Back to OIM Explorer

dbo.QBM_ZDBQueueCompress

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 467 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_PDBQueueCompress source text reference
  • references source dbo.QBM_PJournal source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL24 lines
1CREATE PROCEDURE QBM_ZDBQueueCompress(2  @SlotNumberDummy int = 0,3  @dummy1 varchar(38) = NULL,4  @dummy2 varchar(38) = NULL,5  @GenProcIDDummy varchar(38) = NULL6)7AS8BEGIN9  DECLARE @debuglevel varchar(1) = 'I'10  BEGIN TRY11    EXEC QBM_PDBQueueCompress12    EXEC QBM_PJournal '#LDS#Table DialogDBQueue was compressed without condition.|',13      @@procid,14    'I',15      @DebugLevel16  END TRY17  BEGIN CATCH18    EXEC QBM_PSessionErrorAdd DEFAULT19    RAISERROR('',20    18,21    1)22      WITH NOWAIT23  END CATCH24END
Open raw exported source
SQL ยท Raw4 lines
1     create   procedure QBM_ZDBQueueCompress ( @SlotNumberDummy int = 0 , @dummy1 varchar(38) = null , @dummy2 varchar(38) = null , @GenProcIDDummy2 varchar(38) = null ) as begin declare @debuglevel varchar(1) = 'I' BEGIN TRY exec QBM_PDBQueueCompress exec QBM_PJournal '#LDS#Table DialogDBQueue was compressed without condition.|'3, @@procid, 'I', @DebugLevel END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 4