Back to OIM Explorer

dbo.QBM_ZTriggerWatchCreate

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Single DBQueue insert -> QBM-K-CommonMakeWatchtriggerS / QBM_ZTriggerWatchCreate_S at line 7; References QBM_PDBQueueInsert_Single

Source: sandbox-db sys.sql_modules

Source size: 1.249 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-CommonMakeWatchtriggerS / QBM_ZTriggerWatchCreate_S at line 7
  • References QBM_PDBQueueInsert_Single

Typed Edges

  • queues DBQueue task QBM_ZTriggerWatchCreate_S at line 7 Single DBQueue insert -> QBM-K-CommonMakeWatchtriggerS / QBM_ZTriggerWatchCreate_S at line 7
  • references source dbo.QBM_FGICodeName source text reference
  • references source dbo.QBM_PDBQueueCurrentResetNGen source text reference
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PTableLockEscalationSet source text reference
  • references source dbo.QBM_PTriggerWatchCreate source text reference
  • queues DBQueue task QBM-K-CommonMakeWatchtriggerS -> QBM_ZTriggerWatchCreate_S QBM_PDBQueueInsert_Single 'QBM-K-CommonMakeWatchtriggerS', @TableName, '', @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end

References

Referenced By

Complete Source

SQL67 lines
1CREATE PROCEDURE QBM_ZTriggerWatchCreate(2  @SlotNumber int,3  @TableName varchar(38),4  @Dummy varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @TriggerName varchar(30)10  DECLARE @ResetMessage nvarchar(4000)11  SET XACT_ABORT OFF12  BEGIN TRY13    IF NOT EXISTS(14      SELECT TOP 1 115      FROM QBM_VStartupTables16      WHERE17        tablename = @Tablename)18    BEGIN19      BEGIN TRY20        SELECT21          @TriggerName = dbo.QBM_FGICodeName('T4',22          rtrim(@TableName))23        EXEC QBM_PTriggerWatchCreate @TableName,24        N 'INSERT',25          @TriggerName26        SELECT27          @TriggerName = dbo.QBM_FGICodeName('T5',28          rtrim(@TableName))29        EXEC QBM_PTriggerWatchCreate @TableName,30        N 'UPDATE',31          @TriggerName32        SELECT33          @TriggerName = dbo.QBM_FGICodeName('T6',34          rtrim(@TableName))35        EXEC QBM_PTriggerWatchCreate @TableName,36        N 'DELETE',37          @TriggerName38        EXEC QBM_PTableLockEscalationSet @TableName39      END TRY40      BEGIN CATCH41        EXEC QBM_PSessionErrorAdd DEFAULT42        SELECT @ResetMessage = ERROR_MESSAGE()43        IF @@TRANCOUNT > 044        BEGIN45          ROLLBACK46        END47        EXEC QBM_PDBQueueCurrentResetNGen @SlotNumber,48          @ResetMessage,49          @@PROCID50      END CATCH51    END52    ELSE53    BEGIN54      EXEC QBM_PDBQueueInsert_Single 'QBM-K-CommonMakeWatchtriggerS',55        @TableName,56      '',57        @GenProcID58    END59  END TRY60  BEGIN CATCH61    EXEC QBM_PSessionErrorAdd DEFAULT62    RAISERROR('',63    18,64    1)65      WITH NOWAIT66  END CATCH67END
Open raw exported source
SQL ยท Raw9 lines
1   create   procedure QBM_ZTriggerWatchCreate (@SlotNumber int , @TableName varchar(38) , @Dummy varchar(38) , @GenProcID varchar(38) ) as begin2   declare @TriggerName varchar(30) declare @ResetMessage nvarchar(4000) SET XACT_ABORT OFF BEGIN TRY        if not exists (select top 1 1 from QBM_VStartupTables3 where tablename = @Tablename) begin BEGIN TRY select @TriggerName = dbo.QBM_FGICodeName( 'T4', rtrim(@TableName ))  exec QBM_PTriggerWatchCreate @TableName4 , N'INSERT', @TriggerName select @TriggerName = dbo.QBM_FGICodeName( 'T5', rtrim(@TableName ))  exec QBM_PTriggerWatchCreate @TableName , N'UPDATE', @TriggerName5 select @TriggerName = dbo.QBM_FGICodeName( 'T6', rtrim(@TableName ))  exec QBM_PTriggerWatchCreate @TableName , N'DELETE', @TriggerName  exec QBM_PTableLockEscalationSet6 @TableName END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default select @ResetMessage = ERROR_MESSAGE() if @@TRANCOUNT > 0 begin rollback end  exec QBM_PDBQueueCurrentResetNGen7 @SlotNumber , @ResetMessage , @@PROCID END CATCH end else begin exec QBM_PDBQueueInsert_Single 'QBM-K-CommonMakeWatchtriggerS', @TableName, '', @GenProcID8 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 9