Back to OIM Explorer

dbo.QBM_RXDateSubItemUpdate

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.136 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_FCVElementToObjectKey1 source text reference
  • references source dbo.QBM_FGIPrimaryKeyName source text reference
  • references source dbo.QBM_FGIPrimaryKeyName_F source text reference
  • references source dbo.QBM_FGITableName source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PSlotResetWhileJobRun_L source text reference

References

Referenced By

Complete Source

SQL53 lines
1CREATE PROCEDURE QBM_RXDateSubItemUpdate(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @ObjectKeysToCheck_Jobrunning QBM_YParameterList7  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent8  DECLARE @resetted int9  BEGIN TRY10    INSERT INTO @DBQueueCurrent(UID_DialogDBQueue,11    UID_Parameter,12    UID_SubParameter,13    GenProcID)14    SELECT15      UID_DialogDBQueue,16      UID_Parameter,17      UID_SubParameter,18      GenProcID19    FROM QBMDBQueueCurrent cu20      WITH(readpast)21    WHERE22      cu.SlotNumber = @SlotNumber23    IF @@rowcount = 024    BEGIN25      GOTO EndLabel26    END27    INSERT INTO @ObjectKeysToCheck_Jobrunning(Parameter1,28    Parameter2,29    Parameter3)30    SELECT31      cu.UID_Parameter,32      dbo.QBM_FCVElementToObjectKey1(dbo.QBM_FGITableName(cu.UID_SubParameter),33      dbo.QBM_FGIPrimaryKeyName_F(dbo.QBM_FGITableName(cu.UID_SubParameter), 1),34      cu.UID_Parameter),35      cu.UID_SubParameter36    FROM @DBQueueCurrent cu37    EXEC @resetted = QBM_PSlotResetWhileJobRun_L @DBQueueCurrent,38      @@PROCID,39      @ObjectKeysToCheck_Jobrunning,40      @JobChainNameAddOn = '%',41      @CountParameterOfTask = 2,42      @SlotNumber = @SlotNumber43  END TRY44  BEGIN CATCH45    EXEC QBM_PSessionErrorAdd DEFAULT46    RAISERROR('',47    18,48    1)49      WITH NOWAIT50  END CATCH51  endLabel:52  RETURN53END
Open raw exported source
SQL ยท Raw9 lines
1create   procedure QBM_RXDateSubItemUpdate (@SlotNumber int) AS begin declare @ObjectKeysToCheck_Jobrunning QBM_YParameterList  declare @DBQueueCurrent2 QBM_YDBQueueCurrent declare @resetted int BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select 3UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount4 = 0 begin goto EndLabel end     insert into @ObjectKeysToCheck_Jobrunning(Parameter1, Parameter2, Parameter3) select cu.UID_Parameter  , dbo.QBM_FCVElementToObjectKey15(dbo.QBM_FGITableName(cu.UID_SubParameter  ) , dbo.QBM_FGIPrimaryKeyName_F(dbo.QBM_FGITableName(cu.UID_SubParameter  ), 1) , cu.UID_Parameter  ) , cu.UID_SubParameter6  from @DBQueueCurrent cu exec @resetted = QBM_PSlotResetWhileJobRun_L @DBQueueCurrent, @@PROCID, @ObjectKeysToCheck_Jobrunning , @JobChainNameAddOn = 7'%'  , @CountParameterOfTask = 2 , @SlotNumber = @SlotNumber   END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT 8END CATCH endLabel: return end 9