Back to OIM Explorer

dbo.QBM_PJobCreate_HOTemplate_L

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 2.259 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • Object-layer bridge detected through QBM_PJobCreate helper usage.

Relations

  • References QBM_PJobCreate*

Typed Edges

  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_P5C881179A5B9B0CDCAE541D_ source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOTemplate source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL87 lines
1CREATE PROCEDURE QBM_PJobCreate_HOTemplate_L(2  @objecttype nvarchar(255),3  @XObjectKeys QBM_YParameterList READONLY,4  @Columns nvarchar(max),5  @GenProcID varchar(38),6  @AdditionalObjectKeysAffected QBM_YParameterList READONLY,7  @ConnectionVariables nvarchar(max) = NULL,8  @AuthenticationString nvarchar(max) = NULL,9  @SingleTransaction BIT = 1,10  @isToFreezeOnError BIT = 0,11  @Retries int = 0,12  @priority int = 5,13  @Jobchainname nvarchar(256) = NULL,14  @StartAt datetime = NULL,15  @BasisObjectKey varchar(138) = N '',16  @XUser nvarchar(64) = NULL,17  @WhereClauseAdditional nvarchar(max) = '',18  @checkForExisting BIT = 0,19  @QueueName nvarchar(256) = NULL20)21AS22BEGIN23  DECLARE @Portion int24  DECLARE @PortionMax int25  DECLARE @ElementsMax int26  DECLARE @ElementsLen int27  DECLARE @AllObjectKeysIn QBM_YObjectKeyAndPortion28  SET XACT_ABORT OFF29  BEGIN TRY30    SELECT TOP 1 @ElementsLen = len(Parameter1)31    FROM @XObjectKeys32    IF isnull(@ElementsLen,33    0) = 034    BEGIN35      GOTO endLabel36    END37    SELECT @ElementsMax = 20000 / @ElementsLen38    IF @ElementsMax > 45039    BEGIN40      SELECT @ElementsMax = 45041    END42    INSERT INTO @AllObjectKeysIn(ObjectKey,43    Portion)44    SELECT45      o.Parameter1,46      ((ROW_NUMBER() over(47    ORDER BY o.Parameter1)) / @ElementsMax) + 148    FROM @XObjectKeys o49    SELECT50      @PortionMax = max(i.Portion),51      @Portion = 152    FROM @AllObjectKeysIn i53    WHILE @Portion <= @PortionMax54    BEGIN55      EXEC QBM_P5C881179A5B9B0CDCAE541D_ @Portion = @Portion,56        @AllObjectKeysIn = @AllObjectKeysIn,57        @objecttype = @objecttype,58        @Columns = @Columns,59        @GenProcID = @GenProcID,60        @AdditionalObjectKeysAffected = @AdditionalObjectKeysAffected,61        @ConnectionVariables = @ConnectionVariables,62        @AuthenticationString = @AuthenticationString,63        @SingleTransaction = @SingleTransaction,64        @isToFreezeOnError = @isToFreezeOnError,65        @Retries = @Retries,66        @priority = @priority,67        @Jobchainname = @Jobchainname,68        @StartAt = @StartAt,69        @BasisObjectKey = @BasisObjectKey,70        @XUser = @XUser,71        @WhereClauseAdditional = @WhereClauseAdditional,72        @checkForExisting = @checkForExisting,73        @QueueName = @QueueName74      SELECT @Portion += 175    END76  END TRY77  BEGIN CATCH78    EXEC QBM_PSessionErrorAdd DEFAULT79    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()80    RAISERROR(@Rethrow,81    18,82    1)83      WITH NOWAIT84  END CATCH85  endLabel:86  RETURN87END
Open raw exported source
SQL ยท Raw16 lines
1 create   procedure QBM_PJobCreate_HOTemplate_L( @objecttype nvarchar(255),  @XObjectKeys QBM_YParameterList readonly  , @Columns nvarchar(max) 2 , @GenProcID varchar(38) , @AdditionalObjectKeysAffected QBM_YParameterList readonly    , @ConnectionVariables nvarchar(max) = null , @AuthenticationString3 nvarchar(max) = null , @SingleTransaction bit = 1  , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) =4 null , @StartAt datetime = null , @BasisObjectKey varchar(138) = N'' , @XUser nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = '' , @checkForExisting5 bit = 0 , @QueueName nvarchar(256) = null ) as begin declare @Portion int declare @PortionMax int declare @ElementsMax int declare @ElementsLen int declare6 @AllObjectKeysIn QBM_YObjectKeyAndPortion SET XACT_ABORT OFF BEGIN TRY select top 1 @ElementsLen = len(Parameter1) from @XObjectKeys if isnull(@ElementsLen7, 0) = 0 begin goto endLabel end select @ElementsMax = 20000 / @ElementsLen if @ElementsMax > 450 begin select @ElementsMax = 450 end insert into @AllObjectKeysIn8 (ObjectKey, Portion) select o.Parameter1 , ((ROW_NUMBER() over( order by o.Parameter1) ) / @ElementsMax) + 1 from @XObjectKeys o select @PortionMax = 9max(i.Portion) , @Portion = 1 from @AllObjectKeysIn i while @Portion <= @PortionMax begin exec QBM_P5C881179A5B9B0CDCAE541D_ @Portion = @Portion , @AllObjectKeysIn10 = @AllObjectKeysIn  , @objecttype = @objecttype , @Columns = @Columns , @GenProcID = @GenProcID , @AdditionalObjectKeysAffected = @AdditionalObjectKeysAffected11   , @ConnectionVariables = @ConnectionVariables , @AuthenticationString = @AuthenticationString , @SingleTransaction = @SingleTransaction  , @isToFreezeOnError12 = @isToFreezeOnError , @Retries = @Retries , @priority = @priority , @Jobchainname = @Jobchainname , @StartAt = @StartAt , @BasisObjectKey = @BasisObjectKey13 , @XUser = @XUser , @WhereClauseAdditional = @WhereClauseAdditional , @checkForExisting = @checkForExisting , @QueueName = @QueueName select @Portion 14+= 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 1815, 1) WITH NOWAIT END CATCH endLabel: return end 16