Back to OIM Explorer

dbo.QBM_PDBQueuePrepareForCompiler

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Single DBQueue insert -> at line 3; References QBM_PDBQueueInsert_Single

Source: sandbox-db sys.sql_modules

Source size: 726 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

  • Single DBQueue insert -> at line 3
  • References QBM_PDBQueueInsert_Single

Typed Edges

  • queues DBQueue task at line 3 Single DBQueue insert -> at line 3
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL37 lines
1CREATE PROCEDURE QBM_PDBQueuePrepareForCompiler(2  @UID_Task varchar(38) = 'QBM-K-CommonWaitForCompiler'3)4AS5BEGIN6  DECLARE @result int = 07  DECLARE @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('')8  DECLARE @XUser_R nvarchar(64) = dbo.QBM_FGISessionContext('XUser')9  SET XACT_ABORT OFF10  BEGIN TRY11    IF EXISTS(12      SELECT TOP 1 113      FROM DialogDatabase d14      WHERE15        d.IsMainDatabase = 1 AND UID_CutOffTask IS NULL)16    BEGIN17      EXEC QBM_PDBQueueInsert_Single @UID_Task,18      '',19      '',20        @GenProcID_R21    END22    ELSE23    BEGIN24      SELECT @result = 125    END26  END TRY27  BEGIN CATCH28    EXEC QBM_PSessionErrorAdd DEFAULT29    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()30    RAISERROR(@Rethrow,31    18,32    1)33      WITH NOWAIT34  END CATCH35  ende:36  RETURN(@result)37END
Open raw exported source
SQL ยท Raw6 lines
1    create   procedure QBM_PDBQueuePrepareForCompiler (  @UID_Task varchar(38) = 'QBM-K-CommonWaitForCompiler' ) AS begin declare @result int = 20  declare @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('') declare @XUser_R nvarchar(64) = dbo.QBM_FGISessionContext('XUser') SET XACT_ABORT OFF3 BEGIN TRY if exists (select top 1 1 from DialogDatabase d where d.IsMainDatabase = 1 and UID_CutOffTask is null ) begin exec QBM_PDBQueueInsert_Single4 @UID_Task, '', '', @GenProcID_R end else begin select @result = 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(10005) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return (@result) end 6