Back to OIM Explorer

dbo.QBM_ZProcessShrink

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

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

Source: sandbox-db sys.sql_modules

Source size: 795 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-CommonProcessShrink-Pat / QBM_ZProcessShrink_Pat at line 4
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task QBM_ZProcessShrink_Pat at line 4 Bulk DBQueue insert -> QBM-K-CommonProcessShrink-Pat / QBM_ZProcessShrink_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_PDialogProcessShrink_fill source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task QBM-K-CommonProcessShrink-Pat -> QBM_ZProcessShrink_Pat QBM_PDBQueueInsert_Bulk 'QBM-K-CommonProcessShrink-Pat' , @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

References

Referenced By

Complete Source

SQL42 lines
1CREATE PROCEDURE QBM_ZProcessShrink(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    EXEC QBM_PDialogProcessShrink_fill17    IF dbo.QBM_FGITableCountAll('DialogProcess') > 60000018    BEGIN19      SELECT @HexDigit = 320    END21    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw22    INSERT INTO @DBQueueElements_01(Object,23    SubObject,24    GenProcID)25    SELECT26      h.HexPattern,27      '',28      @GenProcID29    FROM dbo.QBM_FTHexPattern(@HexDigit) h30    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonProcessShrink-Pat',31      @DBQueueElements_0132  END TRY33  BEGIN CATCH34    EXEC QBM_PSessionErrorAdd DEFAULT35    RAISERROR('',36    18,37    1)38      WITH NOWAIT39  END CATCH40  ende:41  RETURN42END
Open raw exported source
SQL ยท Raw6 lines
1        create   procedure QBM_ZProcessShrink ( @SlotNumber int , @dummy1 varchar(38) = '', @dummy2 varchar(38) = '', @GenProcID varchar(38) = ''2 ) as begin declare @HexDigit int = 2 BEGIN TRY if ISNULL(@GenProcID, '') = '' begin select @GenProcID = dbo.QBM_FGISessionContext('') end  exec QBM_PDialogProcessShrink_fill3 if dbo.QBM_FGITableCountAll('DialogProcess') > 600000 begin select @HexDigit = 3 end declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_014(Object, SubObject, GenProcID) select h.HexPattern, '' , @GenProcID from dbo.QBM_FTHexPattern(@HexDigit) h  exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonProcessShrink-Pat'5, @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 6