Back to OIM Explorer

dbo.QBM_PWatchShrink

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 801 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_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PA164BD06A63979BC96DA633_a source text reference
  • references source dbo.QBM_PDialogProcessGetShrinkDef source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL40 lines
1CREATE PROCEDURE QBM_PWatchShrink(2  @KeyPattern varchar(25) = '%'3)4AS5BEGIN6  DECLARE @GrenzDatum datetime7  DECLARE @ReadyForDeleteOrExport int8  DECLARE @BlockSize int = 1000009  DECLARE @lauf int10  DECLARE @DebugSwitch int = 011  DECLARE @DebugMessage nvarchar(1000)12  SET XACT_ABORT OFF13  BEGIN TRY14    EXEC QBM_PDialogProcessGetShrinkDef 'PropertyLog',15      @ReadyForDeleteOrExport OUTPUT,16      @GrenzDatum OUTPUT17    IF @ReadyForDeleteOrExport = 018    BEGIN19      GOTO EndLabel20    END21    SELECT @lauf = 122    WHILE @lauf > 023    BEGIN24      EXEC @lauf = QBM_PA164BD06A63979BC96DA633_a @Blocksize,25        @ReadyForDeleteOrExport,26        @KeyPattern,27        @GrenzDatum28    END29  END TRY30  BEGIN CATCH31    EXEC QBM_PSessionErrorAdd DEFAULT32    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()33    RAISERROR(@Rethrow,34    18,35    1)36      WITH NOWAIT37  END CATCH38  EndLabel:39  RETURN40END
Open raw exported source
SQL ยท Raw6 lines
1create   procedure QBM_PWatchShrink (@KeyPattern varchar(25) = '%'  ) as begin declare @GrenzDatum datetime declare @ReadyForDeleteOrExport int 2declare @BlockSize int = 100000 declare @lauf int declare @DebugSwitch int = 0 declare @DebugMessage nvarchar(1000) SET XACT_ABORT OFF BEGIN TRY exec QBM_PDialogProcessGetShrinkDef3 'PropertyLog', @ReadyForDeleteOrExport output, @GrenzDatum output if @ReadyForDeleteOrExport = 0  begin goto EndLabel end  select @lauf = 1 while @lauf4 > 0 begin exec @lauf = QBM_PA164BD06A63979BC96DA633_a @Blocksize, @ReadyForDeleteOrExport, @KeyPattern, @GrenzDatum end    END TRY BEGIN CATCH exec QBM_PSessionErrorAdd5 default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH EndLabel: return end 6