Back to OIM Explorer

dbo.QBM_ZCheckRIChild

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Single DBQueue insert -> QBM-K-CheckRIAll / QBM_ZCheckRIAll at line 3; References QBM_PDBQueueInsert_Single

Source: sandbox-db sys.sql_modules

Source size: 477 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-CheckRIAll / QBM_ZCheckRIAll at line 3
  • References QBM_PDBQueueInsert_Single

Typed Edges

  • queues DBQueue task QBM_ZCheckRIAll at line 3 Single DBQueue insert -> QBM-K-CheckRIAll / QBM_ZCheckRIAll at line 3
  • references source dbo.QBM_FGIDBOwner source text reference
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PForeignKeyWrongRepair source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task QBM-K-CheckRIAll -> QBM_ZCheckRIAll QBM_PDBQueueInsert_Single 'QBM-K-CheckRIAll', '', '', @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL27 lines
1CREATE PROCEDURE QBM_ZCheckRIChild(2  @SlotNumber int,3  @ChildTablePattern varchar(38),4  @Dummy2 varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @CountItems int10  BEGIN TRY11    IF dbo.QBM_FGIDBOwner() = 'CCC'12    BEGIN13      EXEC @CountItems = QBM_PForeignKeyWrongRepair @ChildTablePattern14      EXEC QBM_PDBQueueInsert_Single 'QBM-K-CheckRIAll',15      '',16      '',17        @GenProcID18    END19  END TRY20  BEGIN CATCH21    EXEC QBM_PSessionErrorAdd DEFAULT22    RAISERROR('',23    18,24    1)25      WITH NOWAIT26  END CATCH27END
Open raw exported source
SQL ยท Raw5 lines
1    create   procedure QBM_ZCheckRIChild ( @SlotNumber int , @ChildTablePattern varchar(38) , @Dummy2 varchar(38) , @GenProcID varchar(38) )  as2 begin  declare @CountItems int BEGIN TRY   if dbo.QBM_FGIDBOwner() = 'CCC' begin exec @CountItems = QBM_PForeignKeyWrongRepair @ChildTablePattern  exec3 QBM_PDBQueueInsert_Single 'QBM-K-CheckRIAll', '', '', @GenProcID end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH4 NOWAIT END CATCH end 5