Back to OIM Explorer

dbo.QBM_ZBufferTProcessTable

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 813 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_PBufferT_ProcessTable source text reference
  • references source dbo.QBM_PJournal source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL43 lines
1CREATE PROCEDURE QBM_ZBufferTProcessTable(2  @SlotNumberDummy int,3  @TableName varchar(38),4  @uid_Module varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @ModuleName varchar(3)10  DECLARE @DebugStarttime datetime = getutcdate()11  DECLARE @DebugLevel char(1) = 'W'12  DECLARE @Debugmessage nvarchar(4000)13  BEGIN TRY14    SELECT @ModuleName =15    LEFT(@uid_module,16    3)17    IF EXISTS(18      SELECT TOP 1 119      FROM QBMBufferTransfer t20      WITH(nolock)21    WHERE22      t.ModuleName = @ModuleName AND t.TableName = @TableName)23    BEGIN24      EXEC QBM_PBufferT_ProcessTable @modulename,25        @TableName,26        @PurgeMode = 027      SELECT @Debugmessage = 'processed Table ' + @TableName28      EXEC QBM_PJournal @Debugmessage,29        @@procid,30      'D',31        @DebugLevel32    END33  END TRY34  BEGIN CATCH35    EXEC QBM_PSessionErrorAdd DEFAULT36    RAISERROR('',37    18,38    1)39      WITH NOWAIT40  END CATCH41  ende:42  RETURN43END
Open raw exported source
SQL ยท Raw7 lines
1  create   procedure QBM_ZBufferTProcessTable (@SlotNumberDummy int  , @TableName varchar(38) , @uid_Module varchar(38) , @GenProcID varchar(38)2 ) AS begin declare @ModuleName varchar(3) declare @DebugStarttime datetime = getutcdate() declare @DebugLevel char(1) = 'W' declare @Debugmessage nvarchar3(4000) BEGIN TRY select @ModuleName = LEFT(@uid_module, 3)  if exists (select top 1 1 from QBMBufferTransfer t with (nolock) where t.ModuleName = @ModuleName4 and t.TableName = @TableName ) begin exec QBM_PBufferT_ProcessTable @modulename, @TableName , @PurgeMode = 0 select @Debugmessage = 'processed Table '5 + @TableName exec QBM_PJournal @Debugmessage, @@procid, 'D', @DebugLevel  end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18,6 1) WITH NOWAIT END CATCH ende: return end 7