Back to OIM Explorer

dbo.QBM_ZProgressViewShrinkReset

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.350 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_PSessionErrorAdd source text reference
  • references source dbo.QBM_ZProgressViewShrink source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL65 lines
1CREATE PROCEDURE QBM_ZProgressViewShrinkReset(2  @SlotNumber int,3  @dummy1 varchar(38) = '',4  @dummy2 varchar(38) = '',5  @GenProcIDDummy varchar(38) = ''6)7AS8BEGIN9  DECLARE @BlockSize int = 10000010  DECLARE @lauf int11  DECLARE @XUser nvarchar(64) = object_name(@@procid)12  DECLARE @Xdate datetime = getutcdate()13  BEGIN TRY14    SELECT @lauf = 115    WHILE @lauf > 016    BEGIN17      UPDATE TOP(@BlockSize) DialogProcessChain18      SET ReadyForDeleteOrExport = 0,19      XDateUpdated = @Xdate,20      XUserUpdated = @XUser21      WHERE22        ReadyForDeleteOrExport > 023      SELECT @lauf = @@ROWCOUNT - @BlockSize + 124    END25    SELECT @lauf = 126    WHILE @lauf > 027    BEGIN28      UPDATE TOP(@BlockSize) DialogWatchOperation29      SET ReadyForDeleteOrExport = 030      WHERE31        ReadyForDeleteOrExport > 032      SELECT @lauf = @@ROWCOUNT - @BlockSize + 133    END34    SELECT @lauf = 135    WHILE @lauf > 036    BEGIN37      UPDATE TOP(@BlockSize) JobHistory38      SET ReadyForDeleteOrExport = 0,39      XDateUpdated = @Xdate,40      XUserUpdated = @XUser41      WHERE42        ReadyForDeleteOrExport > 043      SELECT @lauf = @@ROWCOUNT - @BlockSize + 144    END45    SELECT @lauf = 146    WHILE @lauf > 047    BEGIN48      UPDATE TOP(@BlockSize) DialogProcess49      SET ReadyForDeleteOrExport = 0,50      XDateUpdated = @Xdate,51      XUserUpdated = @XUser52      WHERE53        ReadyForDeleteOrExport > 054      SELECT @lauf = @@ROWCOUNT - @BlockSize + 155    END56  END TRY57  BEGIN CATCH58    EXEC QBM_PSessionErrorAdd DEFAULT59    RAISERROR('',60    18,61    1)62      WITH NOWAIT63  END CATCH64  RETURN65END
Open raw exported source
SQL ยท Raw10 lines
1   create   procedure QBM_ZProgressViewShrinkReset ( @SlotNumber int , @dummy1 varchar(38) = '', @dummy2 varchar(38) = '', @GenProcIDDummy varchar2(38) = '' ) as begin declare @BlockSize int = 100000 declare @lauf int declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate3() BEGIN TRY select @lauf = 1 while @lauf > 0 begin update top (@BlockSize) DialogProcessChain set ReadyForDeleteOrExport = 0 , XDateUpdated = @Xdate ,4 XUserUpdated = @XUser where ReadyForDeleteOrExport > 0 select @lauf = @@ROWCOUNT - @BlockSize + 1 end select @lauf = 1 while @lauf > 0 begin update top5 (@BlockSize) DialogWatchOperation set ReadyForDeleteOrExport = 0 where ReadyForDeleteOrExport > 0 select @lauf = @@ROWCOUNT - @BlockSize + 1 end select6 @lauf = 1 while @lauf > 0 begin update top (@BlockSize) JobHistory set ReadyForDeleteOrExport = 0 , XDateUpdated = @Xdate , XUserUpdated = @XUser where7 ReadyForDeleteOrExport > 0 select @lauf = @@ROWCOUNT - @BlockSize + 1 end select @lauf = 1 while @lauf > 0 begin update top (@BlockSize) DialogProcess8 set ReadyForDeleteOrExport = 0 , XDateUpdated = @Xdate , XUserUpdated = @XUser where ReadyForDeleteOrExport > 0 select @lauf = @@ROWCOUNT - @BlockSize9 + 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH return end 10