Back to OIM Explorer

dbo.QBM_PJobCreate_HOUpdate_L

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 4.732 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_P5B4330B39CD566AFFB80402_ source text reference
references source dbo.QBM_PJobCreate source text reference
references source dbo.QBM_PJobCreate_HOUpdate source text reference
references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

1CREATE PROCEDURE QBM_PJobCreate_HOUpdate_L(2  @objecttype nvarchar(255),3  @XObjectKeys QBM_YParameterList READONLY,4  @GenProcID varchar(38),5  @AdditionalObjectKeysAffected QBM_YParameterList READONLY,6  @ConnectionVariables nvarchar(max) = NULL,7  @AuthenticationString nvarchar(max) = NULL,8  @SingleTransaction BIT = 1,9  @p1 nvarchar(1024) = N '',10  @v1 nvarchar(max) = N '',11  @p2 nvarchar(1024) = N '',12  @v2 nvarchar(max) = N '',13  @p3 nvarchar(1024) = N '',14  @v3 nvarchar(max) = N '',15  @p4 nvarchar(1024) = N '',16  @v4 nvarchar(max) = N '',17  @p5 nvarchar(1024) = N '',18  @v5 nvarchar(max) = N '',19  @p6 nvarchar(1024) = N '',20  @v6 nvarchar(max) = N '',21  @p7 nvarchar(1024) = N '',22  @v7 nvarchar(max) = N '',23  @p8 nvarchar(1024) = N '',24  @v8 nvarchar(max) = N '',25  @p9 nvarchar(1024) = N '',26  @v9 nvarchar(max) = N '',27  @p10 nvarchar(1024) = N '',28  @v10 nvarchar(max) = N '',29  @p11 nvarchar(1024) = N '',30  @v11 nvarchar(max) = N '',31  @p12 nvarchar(1024) = N '',32  @v12 nvarchar(max) = N '',33  @p13 nvarchar(1024) = N '',34  @v13 nvarchar(max) = N '',35  @p14 nvarchar(1024) = N '',36  @v14 nvarchar(max) = N '',37  @p15 nvarchar(1024) = N '',38  @v15 nvarchar(max) = N '',39  @p16 nvarchar(1024) = N '',40  @v16 nvarchar(max) = N '',41  @p17 nvarchar(1024) = N '',42  @v17 nvarchar(max) = N '',43  @p18 nvarchar(1024) = N '',44  @v18 nvarchar(max) = N '',45  @p19 nvarchar(1024) = N '',46  @v19 nvarchar(max) = N '',47  @p20 nvarchar(1024) = N '',48  @v20 nvarchar(max) = N '',49  @p21 nvarchar(1024) = N '',50  @v21 nvarchar(max) = N '',51  @p22 nvarchar(1024) = N '',52  @v22 nvarchar(max) = N '',53  @p23 nvarchar(1024) = N '',54  @v23 nvarchar(max) = N '',55  @p24 nvarchar(1024) = N '',56  @v24 nvarchar(max) = N '',57  @p25 nvarchar(1024) = N '',58  @v25 nvarchar(max) = N '',59  @p26 nvarchar(1024) = N '',60  @v26 nvarchar(max) = N '',61  @p27 nvarchar(1024) = N '',62  @v27 nvarchar(max) = N '',63  @p28 nvarchar(1024) = N '',64  @v28 nvarchar(max) = N '',65  @p29 nvarchar(1024) = N '',66  @v29 nvarchar(max) = N '',67  @p30 nvarchar(1024) = N '',68  @v30 nvarchar(max) = N '',69  @p31 nvarchar(1024) = N '',70  @v31 nvarchar(max) = N '',71  @isToFreezeOnError BIT = 0,72  @Retries int = 0,73  @priority int = 5,74  @Jobchainname nvarchar(256) = NULL,75  @StartAt datetime = NULL,76  @BasisObjectKey varchar(138) = N '',77  @XUser nvarchar(64) = NULL,78  @WhereClauseAdditional nvarchar(max) = '',79  @checkForExisting BIT = 0,80  @QueueName nvarchar(256) = NULL81)82AS83BEGIN84  DECLARE @Portion int85  DECLARE @PortionMax int86  DECLARE @ElementsMax int87  DECLARE @ElementsLen int88  DECLARE @AllObjectKeysIn QBM_YObjectKeyAndPortion89  SET XACT_ABORT OFF90  BEGIN TRY91    SELECT TOP 1 @ElementsLen = len(Parameter1)92    FROM @XObjectKeys93    IF isnull(@ElementsLen,94    0) = 095    BEGIN96      GOTO endLabel97    END98    SELECT @ElementsMax = 20000 / @ElementsLen99    IF @ElementsMax > 450100    BEGIN101      SELECT @ElementsMax = 450102    END103    INSERT INTO @AllObjectKeysIn(ObjectKey,104    Portion)105    SELECT106      o.Parameter1,107      ((ROW_NUMBER() over(108    ORDER BY o.Parameter1)) / @ElementsMax) + 1109    FROM @XObjectKeys o110    SELECT111      @PortionMax = max(i.Portion),112      @Portion = 1113    FROM @AllObjectKeysIn i114    WHILE @Portion <= @PortionMax115    BEGIN116      EXEC QBM_P5B4330B39CD566AFFB80402_ @Portion = @Portion,117        @AllObjectKeysIn = @AllObjectKeysIn,118        @objecttype = @objecttype,119        @GenProcID = @GenProcID,120        @AdditionalObjectKeysAffected = @AdditionalObjectKeysAffected,121        @ConnectionVariables = @ConnectionVariables,122        @AuthenticationString = @AuthenticationString,123        @SingleTransaction = @SingleTransaction,124        @p1 = @p1,125        @v1 = @v1,126        @p2 = @p2,127        @v2 = @v2,128        @p3 = @p3,129        @v3 = @v3,130        @p4 = @p4,131        @v4 = @v4,132        @p5 = @p5,133        @v5 = @v5,134        @p6 = @p6,135        @v6 = @v6,136        @p7 = @p7,137        @v7 = @v7,138        @p8 = @p8,139        @v8 = @v8,140        @p9 = @p9,141        @v9 = @v9,142        @p10 = @p10,143        @v10 = @v10,144        @p11 = @p11,145        @v11 = @v11,146        @p12 = @p12,147        @v12 = @v12,148        @p13 = @p13,149        @v13 = @v13,150        @p14 = @p14,151        @v14 = @v14,152        @p15 = @p15,153        @v15 = @v15,154        @p16 = @p16,155        @v16 = @v16,156        @p17 = @p17,157        @v17 = @v17,158        @p18 = @p18,159        @v18 = @v18,160        @p19 = @p19,161        @v19 = @v19,162        @p20 = @p20,163        @v20 = @v20,164        @p21 = @p21,165        @v21 = @v21,166        @p22 = @p22,167        @v22 = @v22,168        @p23 = @p23,169        @v23 = @v23,170        @p24 = @p24,171        @v24 = @v24,172        @p25 = @p25,173        @v25 = @v25,174        @p26 = @p26,175        @v26 = @v26,176        @p27 = @p27,177        @v27 = @v27,178        @p28 = @p28,179        @v28 = @v28,180        @p29 = @p29,181        @v29 = @v29,182        @p30 = @p30,183        @v30 = @v30,184        @p31 = @p31,185        @v31 = @v31,186        @isToFreezeOnError = @isToFreezeOnError,187        @Retries = @Retries,188        @priority = @priority,189        @Jobchainname = @Jobchainname,190        @StartAt = @StartAt,191        @BasisObjectKey = @BasisObjectKey,192        @XUser = @XUser,193        @WhereClauseAdditional = @WhereClauseAdditional,194        @checkForExisting = @checkForExisting,195        @QueueName = @QueueName196      SELECT @Portion += 1197    END198  END TRY199  BEGIN CATCH200    EXEC QBM_PSessionErrorAdd DEFAULT201    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()202    RAISERROR(@Rethrow,203    18,204    1)205      WITH NOWAIT206  END CATCH207  endLabel:208  RETURN209END

Open raw exported source

1 create   procedure QBM_PJobCreate_HOUpdate_L( @objecttype nvarchar(255),  @XObjectKeys QBM_YParameterList readonly,  @GenProcID varchar(38) , @AdditionalObjectKeysAffected2 QBM_YParameterList readonly    , @ConnectionVariables nvarchar(max) = null , @AuthenticationString nvarchar(max) = null , @SingleTransaction bit = 1 ,3 @p1 nvarchar (1024) = N'', @v1 nvarchar (max) = N'' , @p2 nvarchar (1024) = N'', @v2 nvarchar (max) = N'' , @p3 nvarchar (1024) = N'', @v3 nvarchar (max4) = N'' , @p4 nvarchar (1024) = N'', @v4 nvarchar (max) = N'' , @p5 nvarchar (1024) = N'', @v5 nvarchar (max) = N'' , @p6 nvarchar (1024) = N'', @v6 nvarchar5 (max) = N'' , @p7 nvarchar (1024) = N'', @v7 nvarchar (max) = N'' , @p8 nvarchar (1024) = N'', @v8 nvarchar (max) = N'' , @p9 nvarchar (1024) = N'', @v96 nvarchar (max) = N'' , @p10 nvarchar (1024) = N'', @v10 nvarchar (max) = N'' , @p11 nvarchar (1024) = N'', @v11 nvarchar (max) = N'' , @p12 nvarchar (10247) = N'', @v12 nvarchar (max) = N'' , @p13 nvarchar (1024) = N'', @v13 nvarchar (max) = N'' , @p14 nvarchar (1024) = N'', @v14 nvarchar (max) = N'' , @p158 nvarchar (1024) = N'', @v15 nvarchar (max) = N'' , @p16 nvarchar (1024) = N'', @v16 nvarchar (max) = N'' , @p17 nvarchar (1024) = N'', @v17 nvarchar (max9) = N'' , @p18 nvarchar (1024) = N'', @v18 nvarchar (max) = N'' , @p19 nvarchar (1024) = N'', @v19 nvarchar (max) = N'' , @p20 nvarchar (1024) = N'', @v2010 nvarchar (max) = N'' , @p21 nvarchar (1024) = N'', @v21 nvarchar (max) = N'' , @p22 nvarchar (1024) = N'', @v22 nvarchar (max) = N'' , @p23 nvarchar (102411) = N'', @v23 nvarchar (max) = N'' , @p24 nvarchar (1024) = N'', @v24 nvarchar (max) = N'' , @p25 nvarchar (1024) = N'', @v25 nvarchar (max) = N'' , @p2612 nvarchar (1024) = N'', @v26 nvarchar (max) = N'' , @p27 nvarchar (1024) = N'', @v27 nvarchar (max) = N'' , @p28 nvarchar (1024) = N'', @v28 nvarchar (max13) = N'' , @p29 nvarchar (1024) = N'', @v29 nvarchar (max) = N'' , @p30 nvarchar (1024) = N'', @v30 nvarchar (max) = N'' , @p31 nvarchar (1024) = N'', @v3114 nvarchar (max) = N'' , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) = null , @StartAt datetime = null15 , @BasisObjectKey varchar(138) = N'' , @XUser nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = '' , @checkForExisting bit = 0 , @QueueName16 nvarchar(256) = null ) as begin declare @Portion int declare @PortionMax int declare @ElementsMax int declare @ElementsLen int declare @AllObjectKeysIn17 QBM_YObjectKeyAndPortion SET XACT_ABORT OFF BEGIN TRY select top 1 @ElementsLen = len(Parameter1) from @XObjectKeys if isnull(@ElementsLen, 0) = 0 begin18 goto endLabel end select @ElementsMax = 20000 / @ElementsLen if @ElementsMax > 450 begin select @ElementsMax = 450 end insert into @AllObjectKeysIn (ObjectKey19, Portion) select o.Parameter1 , ((ROW_NUMBER() over( order by o.Parameter1) ) / @ElementsMax) + 1 from @XObjectKeys o select @PortionMax = max(i.Portion20) , @Portion = 1 from @AllObjectKeysIn i while @Portion <= @PortionMax begin exec QBM_P5B4330B39CD566AFFB80402_ @Portion = @Portion , @AllObjectKeysIn 21= @AllObjectKeysIn  , @objecttype = @objecttype     , @GenProcID = @GenProcID , @AdditionalObjectKeysAffected = @AdditionalObjectKeysAffected   , @ConnectionVariables22 = @ConnectionVariables , @AuthenticationString = @AuthenticationString , @SingleTransaction = @SingleTransaction , @p1 = @p1, @v1 = @v1, @p2 = @p2 , @v223 = @v2, @p3 = @p3, @v3 = @v3, @p4 = @p4, @v4 = @v4, @p5 = @p5, @v5 = @v5, @p6 = @p6, @v6 = @v6, @p7 = @p7, @v7 = @v7, @p8 = @p8, @v8 = @v8, @p9 = @p9, 24@v9 = @v9, @p10 = @p10, @v10 = @v10, @p11 = @p11, @v11 = @v11, @p12 = @p12, @v12 = @v12, @p13 = @p13, @v13 = @v13, @p14 = @p14, @v14 = @v14, @p15 = @p1525, @v15 = @v15, @p16 = @p16, @v16 = @v16, @p17 = @p17, @v17 = @v17, @p18 = @p18, @v18 = @v18, @p19 = @p19, @v19 = @v19, @p20 = @p20, @v20 = @v20, @p21 =26 @p21, @v21 = @v21, @p22 = @p22, @v22 = @v22, @p23 = @p23, @v23 = @v23, @p24 = @p24, @v24 = @v24, @p25 = @p25, @v25 = @v25, @p26 = @p26, @v26 = @v26, @p2727 = @p27, @v27 = @v27, @p28 = @p28, @v28 = @v28, @p29 = @p29, @v29 = @v29, @p30 = @p30, @v30 = @v30, @p31 = @p31, @v31 = @v31 , @isToFreezeOnError = @isToFreezeOnError28 , @Retries = @Retries , @priority = @priority , @Jobchainname = @Jobchainname , @StartAt = @StartAt , @BasisObjectKey = @BasisObjectKey , @XUser = @XUser29 , @WhereClauseAdditional = @WhereClauseAdditional , @checkForExisting = @checkForExisting , @QueueName = @QueueName select @Portion += 1 end END TRY BEGIN30 CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END 31CATCH endLabel: return end 32