Back to OIM Explorer

dbo.QBM_ZWatchShrink

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> QBM-K-CommonShrinkPropertyLog-Pat / QBM_ZWatchShrink_Pat at line 4; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 759 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-CommonShrinkPropertyLog-Pat / QBM_ZWatchShrink_Pat at line 4
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task QBM_ZWatchShrink_Pat at line 4 Bulk DBQueue insert -> QBM-K-CommonShrinkPropertyLog-Pat / QBM_ZWatchShrink_Pat at line 4
  • references source dbo.QBM_FTHexPattern source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_FGITableCountAll source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task QBM-K-CommonShrinkPropertyLog-Pat -> QBM_ZWatchShrink_Pat QBM_PDBQueueInsert_Bulk 'QBM-K-CommonShrinkPropertyLog-Pat' , @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH return end

References

Referenced By

Complete Source

SQL40 lines
1CREATE PROCEDURE QBM_ZWatchShrink(2  @SlotNumber int,3  @dummy1 varchar(38) = '',4  @dummy2 varchar(38) = '',5  @GenProcID varchar(38) = ''6)7AS8BEGIN9  DECLARE @HexDigit int = 210  BEGIN TRY11    IF ISNULL(@GenProcID,12    '') = ''13    BEGIN14      SELECT @GenProcID = dbo.QBM_FGISessionContext('')15    END16    IF dbo.QBM_FGITableCountAll('DialogWatchOperation') > 60000017    BEGIN18      SELECT @HexDigit = 319    END20    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw21    INSERT INTO @DBQueueElements_01(Object,22    SubObject,23    GenProcID)24    SELECT25      h.HexPattern,26      '',27      @GenProcID28    FROM dbo.QBM_FTHexPattern(@HexDigit) h29    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonShrinkPropertyLog-Pat',30      @DBQueueElements_0131  END TRY32  BEGIN CATCH33    EXEC QBM_PSessionErrorAdd DEFAULT34    RAISERROR('',35    18,36    1)37      WITH NOWAIT38  END CATCH39  RETURN40END
Open raw exported source
SQL ยท Raw6 lines
1       create   procedure QBM_ZWatchShrink ( @SlotNumber int , @dummy1 varchar(38) = '', @dummy2 varchar(38)= '', @GenProcID varchar(38)= '' ) as2 begin declare @HexDigit int = 2 BEGIN TRY if ISNULL(@GenProcID, '') = '' begin select @GenProcID = dbo.QBM_FGISessionContext('') end if dbo.QBM_FGITableCountAll3('DialogWatchOperation') > 600000 begin select @HexDigit = 3 end declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01(Object, SubObject4, GenProcID) select h.HexPattern, '' , @GenProcID from dbo.QBM_FTHexPattern(@HexDigit) h  exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonShrinkPropertyLog-Pat'5, @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH return end 6