Back to OIM Explorer

dbo.QBM_ZPrePropAll

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 5; References QBM_PDBQueueInsert_Single

Source: sandbox-db sys.sql_modules

Source size: 966 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 -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 5
  • References QBM_PDBQueueInsert_Single

Typed Edges

  • queues DBQueue task QBM_ZRecalculate at line 5 Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 5
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task QBM-K-CommonReCalculate -> QBM_ZRecalculate QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate' , @UID_Task, Null, @GenProcID select @ElementIndex += 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL46 lines
1CREATE PROCEDURE QBM_ZPrePropAll(2  @SlotNumberDummy int,3  @dummy1 varchar(38),4  @dummy2 varchar(38),5  @dummyGenProcid varchar(38)6)7AS8BEGIN9  DECLARE @GenProcID varchar(38) = newid()10  DECLARE @UID_Task varchar(38)11  DECLARE @SortOrder int12  DECLARE @ElementBuffer QBM_YCursorBuffer13  DECLARE @ElementCount int14  DECLARE @ElementIndex int15  BEGIN TRY16    INSERT INTO @ElementBuffer(UID1)17    SELECT18      DISTINCT t.UID_Task AS uid19    FROM QBMDBQueueTask t20    WHERE21      QueryForRecalculate > ' ' AND UID_TaskAutomatedFollower = 'QBM-K-PrepropFinished'22    SELECT @ElementCount = @@ROWCOUNT23    SELECT @ElementIndex = 124    WHILE @ElementIndex <= @ElementCount25    BEGIN26      SELECT TOP 1 @UID_Task = bu.UID127      FROM @ElementBuffer bu28      WHERE29        bu.ElementIndex = @ElementIndex30      EXEC QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate',31        @UID_Task,32      NULL,33        @GenProcID34      SELECT @ElementIndex += 135    END36  END TRY37  BEGIN CATCH38    EXEC QBM_PSessionErrorAdd DEFAULT39    RAISERROR('',40    18,41    1)42      WITH NOWAIT43  END CATCH44  ende:45  RETURN46END
Open raw exported source
SQL ยท Raw8 lines
1    create   procedure QBM_ZPrePropAll (@SlotNumberDummy int , @dummy1 varchar(38) , @dummy2 varchar(38) , @dummyGenProcid varchar(38) ) as begin2  declare @GenProcID varchar(38) = newid() declare @UID_Task varchar(38) declare @SortOrder int declare @ElementBuffer QBM_YCursorBuffer declare @ElementCount3 int declare @ElementIndex int BEGIN TRY  insert into @ElementBuffer (UID1) select distinct t.UID_Task as uid from QBMDBQueueTask t where QueryForRecalculate4 > ' ' and UID_TaskAutomatedFollower = 'QBM-K-PrepropFinished' select @ElementCount = @@ROWCOUNT select @ElementIndex = 1 while @ElementIndex <= @ElementCount5 begin select top 1 @UID_Task = bu.UID1 from @ElementBuffer bu where bu.ElementIndex = @ElementIndex exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate'6, @UID_Task, Null, @GenProcID select @ElementIndex += 1 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END7 CATCH  ende: return end 8