Back to OIM Explorer

dbo.QBM_PJobCreate_HOUpdate

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 4.269 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_FGIJobCreateName source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL209 lines
1CREATE PROCEDURE QBM_PJobCreate_HOUpdate(2  @objecttype nvarchar(255),3  @whereclause nvarchar(max),4  @GenProcID varchar(38),5  @ObjectKeysAffected 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 @Parameters QBM_YParameterList85  DECLARE @JobChainNameAddOn nvarchar(256)86  SET XACT_ABORT OFF87  BEGIN TRY88    IF @Jobchainname IS NULL89    BEGIN90      SELECT @JobChainNameAddOn = ' handle object update for object type ' + @objecttype91      SELECT @Jobchainname =dbo.QBM_FGIJobCreateName(@JobChainNameAddOn)92    END93    INSERT INTO @Parameters(Parameter1,94    ContentFull)95    VALUES('objecttype',96    @objecttype),97    ('WhereClause',98    @whereclause),99    ('WhereClauseAdditional',100    @WhereClauseAdditional),101    (@p1,102    @v1),103    (@p2,104    @v2),105    (@p3,106    @v3),107    (@p4,108    @v4),109    (@p5,110    @v5),111    (@p6,112    @v6),113    (@p7,114    @v7),115    (@p8,116    @v8),117    (@p9,118    @v9),119    (@p10,120    @v10),121    (@p11,122    @v11),123    (@p12,124    @v12),125    (@p13,126    @v13),127    (@p14,128    @v14),129    (@p15,130    @v15),131    (@p16,132    @v16),133    (@p17,134    @v17),135    (@p18,136    @v18),137    (@p19,138    @v19),139    (@p20,140    @v20),141    (@p21,142    @v21),143    (@p22,144    @v22),145    (@p23,146    @v23),147    (@p24,148    @v24),149    (@p25,150    @v25),151    (@p26,152    @v26),153    (@p27,154    @v27),155    (@p28,156    @v28),157    (@p29,158    @v29),159    (@p30,160    @v30),161    (@p31,162    @v31)163    IF @ConnectionVariables > ' '164    BEGIN165      INSERT INTO @Parameters(Parameter1,166      ContentFull)167      VALUES('ConnectionVariables',168      @ConnectionVariables)169    END170    IF @AuthenticationString > ' '171    BEGIN172      INSERT INTO @Parameters(Parameter1,173      ContentFull)174      VALUES('AuthenticationString',175      @AuthenticationString)176    END177    IF @SingleTransaction = 0178    BEGIN179      INSERT INTO @Parameters(Parameter1,180      ContentFull)181      VALUES('SingleTransaction',182      'FALSE')183    END184    EXEC QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent',185    'Update',186      @Parameters,187      @GenProcID,188      @ObjectKeysAffected,189      @isToFreezeOnError,190      @Retries,191      @priority,192      @Jobchainname,193      @StartAt,194      @BasisObjectKey,195      @XUser,196      @QueueName,197      @checkForExisting = @checkForExisting198  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  ende:208  RETURN209END
Open raw exported source
SQL ยท Raw29 lines
1create   procedure QBM_PJobCreate_HOUpdate( @objecttype nvarchar(255),  @whereclause nvarchar(max),  @GenProcID varchar(38) , @ObjectKeysAffected2 QBM_YParameterList readOnly  , @ConnectionVariables nvarchar(max) = null , @AuthenticationString nvarchar(max) = null , @SingleTransaction bit = 1 , @p13 nvarchar (1024) = N'', @v1 nvarchar (max) = N'' , @p2 nvarchar (1024) = N'', @v2 nvarchar (max) = N'' , @p3 nvarchar (1024) = N'', @v3 nvarchar (max) 4= 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 @Parameters QBM_YParameterList declare @JobChainNameAddOn nvarchar(256) SET XACT_ABORT OFF BEGIN TRY if @Jobchainname17 is null begin select @JobChainNameAddOn = ' handle object update for object type ' + @objecttype select @Jobchainname =dbo.QBM_FGIJobCreateName ( @JobChainNameAddOn18) end insert into @Parameters (Parameter1, ContentFull) values ('objecttype', @objecttype) , ('WhereClause', @whereclause) , ('WhereClauseAdditional', 19@WhereClauseAdditional)  , ( @p1 , @v1 ) , ( @p2 , @v2 ) , ( @p3 , @v3 ) , ( @p4 , @v4 ) , ( @p5 , @v5 ) , ( @p6 , @v6 ) , ( @p7 , @v7 ) , ( @p8 , @v8 20) , ( @p9 , @v9 ) , ( @p10 , @v10 ) , ( @p11 , @v11 ) , ( @p12 , @v12 ) , ( @p13 , @v13 ) , ( @p14 , @v14 ) , ( @p15 , @v15 ) , ( @p16 , @v16 ) , ( @p1721 , @v17 ) , ( @p18 , @v18 ) , ( @p19 , @v19 ) , ( @p20 , @v20 ) , ( @p21 , @v21 ) , ( @p22 , @v22 ) , ( @p23 , @v23 ) , ( @p24 , @v24 ) , ( @p25 , @v2522 ) , ( @p26 , @v26 ) , ( @p27 , @v27 ) , ( @p28 , @v28 ) , ( @p29 , @v29 ) , ( @p30 , @v30 ) , ( @p31 , @v31 ) if @ConnectionVariables > ' ' begin insert23 into @Parameters(Parameter1, ContentFull) values ('ConnectionVariables', @ConnectionVariables) end if @AuthenticationString > ' ' begin insert into @Parameters24(Parameter1, ContentFull) values ('AuthenticationString', @AuthenticationString) end if @SingleTransaction = 0 begin insert into @Parameters(Parameter125, ContentFull) values ('SingleTransaction', 'FALSE') end exec QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent' , 'Update' , @Parameters26 , @GenProcID , @ObjectKeysAffected , @isToFreezeOnError , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @QueueName , @checkForExisting27 = @checkForExisting END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR 28(@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 29