Back to OIM Explorer

dbo.QBM_ZIndexRebuild

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 752 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • Object-layer bridge detected through QBM_PJobCreate helper usage.

Relations

  • References QBM_PJobCreate*

Typed Edges

  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PIndexRebuild source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_Mnt source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL39 lines
1CREATE PROCEDURE QBM_ZIndexRebuild(2  @SlotNumberDummy int,3  @TableName varchar(38),4  @dummy1 varchar(38) = '',5  @GenProcID varchar(38) = ''6)7AS8BEGIN9  DECLARE @Message nvarchar(1000) = '#LDS#Reindexing of {0} was not performed due to the size of the table.|' + @tablename + '|'10  DECLARE @DebugLevel varchar(1) = 'W'11  BEGIN TRY12    IF ISNULL(@GenProcID,13    '') = ''14    BEGIN15      SELECT @GenProcID = dbo.QBM_FGISessionContext('')16    END17    IF 1=018    BEGIN19      EXEC QBM_PIndexRebuild @TableName20    END21    ELSE22    BEGIN23      DECLARE @SQL33734 nvarchar(max) = CONCAT('exec QBM_PIndexRebuild ''',24      @TableName,25      '''')26      EXEC QBM_PJobCreate_Mnt @SQL33734,27        @GenProcID28    END29  END TRY30  BEGIN CATCH31    EXEC QBM_PSessionErrorAdd DEFAULT32    RAISERROR('',33    18,34    1)35      WITH NOWAIT36  END CATCH37  endLabel:38  RETURN39END
Open raw exported source
SQL ยท Raw6 lines
1    create   procedure QBM_ZIndexRebuild ( @SlotNumberDummy int , @TableName varchar(38), @dummy1 varchar(38) = '', @GenProcID varchar(38) = '' 2) as begin declare @Message nvarchar(1000) = '#LDS#Reindexing of {0} was not performed due to the size of the table.|' + @tablename + '|' declare @DebugLevel3 varchar(1) = 'W' BEGIN TRY  if ISNULL(@GenProcID, '') = '' begin select @GenProcID = dbo.QBM_FGISessionContext('') end  if 1=0 begin exec QBM_PIndexRebuild4 @TableName end else begin declare @SQL33734 nvarchar(max) = concat('exec QBM_PIndexRebuild ''', @TableName, '''' ) exec QBM_PJobCreate_Mnt @SQL33734, 5@GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 6