Back to OIM Explorer

dbo.QBM_ZTableReload

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 724 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_PDBQueueCurrentResetNGen source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PTableReload source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL43 lines
1CREATE PROCEDURE QBM_ZTableReload(2  @SlotNumberDummy int,3  @TableName varchar(38),4  @Dummy varchar(38),5  @Genprocid varchar(38)6)7AS8BEGIN9  DECLARE @ResetMessage nvarchar(4000)10  BEGIN TRY11    IF @TableName IN('DialogTable',12    'DialogColumn',13    'QBMDBQueueTask')14    BEGIN15      GOTO endLabel16    END17    BEGIN TRY18      EXEC QBM_PTableReload @TableName,19        @WithReplace = 0,20        @Genprocid = @Genprocid21    END TRY22    BEGIN CATCH23      EXEC QBM_PSessionErrorAdd DEFAULT24      SELECT @ResetMessage = ERROR_MESSAGE()25      IF @@TRANCOUNT > 026      BEGIN27        ROLLBACK28      END29      EXEC QBM_PDBQueueCurrentResetNGen @SlotNumberDummy,30        @ResetMessage,31        @@PROCID32    END CATCH33  END TRY34  BEGIN CATCH35    EXEC QBM_PSessionErrorAdd DEFAULT36    RAISERROR('',37    18,38    1)39      WITH NOWAIT40  END CATCH41  endLabel:42  RETURN43END
Open raw exported source
SQL ยท Raw6 lines
1       create   procedure QBM_ZTableReload (@SlotNumberDummy int , @TableName varchar(38) , @Dummy varchar(38) , @Genprocid varchar(38) ) as begin2 declare @ResetMessage nvarchar(4000) BEGIN TRY if @TableName in ('DialogTable' , 'DialogColumn' , 'QBMDBQueueTask' ) begin goto endLabel end BEGIN TRY3 exec QBM_PTableReload @TableName , @WithReplace = 0, @Genprocid = @Genprocid END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default select @ResetMessage4 = ERROR_MESSAGE() if @@TRANCOUNT > 0 begin rollback end  exec QBM_PDBQueueCurrentResetNGen @SlotNumberDummy , @ResetMessage , @@PROCID END CATCH END TRY5 BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 6