Back to OIM Explorer

dbo.QBM_ZBufferTProcessModulePU

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> QBM-K-BufferTProcessTablePU / QBM_ZBufferTProcessTablePU at line 6; Single DBQueue insert -> QBM-K-BufferTProcessDelete / QBM_ZBufferTProcessDelete at line 6; References QBM_PDBQueueInsert_Single; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 1.123 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

  • Bulk DBQueue insert -> QBM-K-BufferTProcessTablePU / QBM_ZBufferTProcessTablePU at line 6
  • Single DBQueue insert -> QBM-K-BufferTProcessDelete / QBM_ZBufferTProcessDelete at line 6
  • References QBM_PDBQueueInsert_Single
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task QBM_ZBufferTProcessTablePU at line 6 Bulk DBQueue insert -> QBM-K-BufferTProcessTablePU / QBM_ZBufferTProcessTablePU at line 6
  • queues DBQueue task QBM_ZBufferTProcessDelete at line 6 Single DBQueue insert -> QBM-K-BufferTProcessDelete / QBM_ZBufferTProcessDelete at line 6
  • references source dbo.QBM_FGIModulePrecedenceValid source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_ZBufferTProcessModule source text reference
  • queues DBQueue task QBM-K-BufferTProcessTablePU -> QBM_ZBufferTProcessTablePU QBM_PDBQueueInsert_Bulk 'QBM-K-BufferTProcessTablePU', @DBQueueElements_01 exec QBM_PDBQueueInsert_Single 'QBM-K-BufferTProcessDelete', @uid_Module, '', @GenProcID END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1)…
  • queues DBQueue task QBM-K-BufferTProcessDelete -> QBM_ZBufferTProcessDelete QBM_PDBQueueInsert_Single 'QBM-K-BufferTProcessDelete', @uid_Module, '', @GenProcID 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

SQL57 lines
1CREATE PROCEDURE QBM_ZBufferTProcessModulePU(2  @SlotNumber int,3  @uid_Module varchar(38),4  @Dummy2 varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @ModuleName varchar(3)10  BEGIN TRY11    SELECT @ModuleName =12    LEFT(@uid_module,13    3)14    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw15    INSERT INTO @DBQueueElements_01(object,16    subobject,17    GenProcID)18    SELECT19      x.uid,20      @uid_module,21      @GenProcID22    FROM(23    SELECT TableName AS uid24    FROM QBMBufferTransfer t25      WITH(nolock)26    WHERE27      ModuleName = @ModuleName28    UNION29    SELECT TableName AS uid30    FROM DialogTable t31    WHERE32      dbo.QBM_FGIModulePrecedenceValid(t.XObjectKey, @uid_Module) = 1 AND NOT EXISTS(33    SELECT TOP 1 134    FROM QBM_VStartupTables v35    WHERE36      v.TableName = t.TableName) AND EXISTS(37    SELECT TOP 1 138    FROM dialogcolumn c39    WHERE40      c.uid_dialogtable = t.uid_dialogtable AND c.ColumnName = 'XObjectKey')) AS x41    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-BufferTProcessTablePU',42      @DBQueueElements_0143    EXEC QBM_PDBQueueInsert_Single 'QBM-K-BufferTProcessDelete',44      @uid_Module,45    '',46      @GenProcID47  END TRY48  BEGIN CATCH49    EXEC QBM_PSessionErrorAdd DEFAULT50    RAISERROR('',51    18,52    1)53      WITH NOWAIT54  END CATCH55  ende:56  RETURN57END
Open raw exported source
SQL · Raw9 lines
1  create   procedure QBM_ZBufferTProcessModulePU (@SlotNumber int , @uid_Module varchar(38) , @Dummy2 varchar(38) , @GenProcID varchar(38) ) AS 2begin declare @ModuleName varchar(3) BEGIN TRY select @ModuleName = LEFT(@uid_module, 3)  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_013(object, subobject, GenProcID)  select x.uid, @uid_module, @GenProcID from (select TableName as uid from QBMBufferTransfer t with (nolock) where ModuleName4 = @ModuleName  union select TableName as uid from DialogTable t where dbo.QBM_FGIModulePrecedenceValid(t.XObjectKey, @uid_Module) = 1  and not exists 5(select top 1 1 from QBM_VStartupTables v where v.TableName = t.TableName ) and exists (select top 1 1 from dialogcolumn c where c.uid_dialogtable = t.uid_dialogtable6 and c.ColumnName = 'XObjectKey' ) ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-BufferTProcessTablePU', @DBQueueElements_01 exec QBM_PDBQueueInsert_Single7 'QBM-K-BufferTProcessDelete', @uid_Module, '', @GenProcID END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END 8CATCH ende: return end 9