Back to OIM Explorer

dbo.QBM_PJobCreate_HOUpdate_B

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 4.548 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_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOUpdate source text reference
  • references source dbo.QBM_PJobCreate_HOUpdate_L source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL276 lines
1CREATE PROCEDURE QBM_PJobCreate_HOUpdate_B(2  @objecttype nvarchar(255),3  @whereclause nvarchar(max),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 @XObjectKeysToTransfer QBM_YParameterList85  DECLARE @SQLCmd nvarchar(max)86  SET XACT_ABORT OFF87  BEGIN TRY88    IF EXISTS(89      SELECT TOP 1 190      FROM DialogTable t91      WITH(readpast)92    JOIN DialogColumn c93      WITH(readpast)94      ON t.UID_DialogTable = c.UID_DialogTable95    WHERE96      t.TableName = @objecttype AND c.ColumnName = 'XObjectKey')97    BEGIN98      SELECT99        @SQLCmd = N '100	  select XObjectKey 101		from ' + @objecttype + N '102		where ( ' + @whereclause + N ' )103		order by 1 '104      INSERT INTO @XObjectKeysToTransfer(Parameter1)105      EXEC sp_executeSQL @SQLCmd106      EXEC QBM_PJobCreate_HOUpdate_L @objecttype,107        @XObjectKeysToTransfer,108        @GenProcID,109        @AdditionalObjectKeysAffected,110        @ConnectionVariables,111        @AuthenticationString,112        @SingleTransaction,113        @p1,114        @v1,115        @p2,116        @v2,117        @p3,118        @v3,119        @p4,120        @v4,121        @p5,122        @v5,123        @p6,124        @v6,125        @p7,126        @v7,127        @p8,128        @v8,129        @p9,130        @v9,131        @p10,132        @v10,133        @p11,134        @v11,135        @p12,136        @v12,137        @p13,138        @v13,139        @p14,140        @v14,141        @p15,142        @v15,143        @p16,144        @v16,145        @p17,146        @v17,147        @p18,148        @v18,149        @p19,150        @v19,151        @p20,152        @v20,153        @p21,154        @v21,155        @p22,156        @v22,157        @p23,158        @v23,159        @p24,160        @v24,161        @p25,162        @v25,163        @p26,164        @v26,165        @p27,166        @v27,167        @p28,168        @v28,169        @p29,170        @v29,171        @p30,172        @v30,173        @p31,174        @v31,175        @isToFreezeOnError,176        @Retries,177        @priority,178        @Jobchainname,179        @StartAt,180        @BasisObjectKey,181        @XUser,182        @WhereClauseAdditional,183        @checkForExisting,184        @QueueName185    END186    ELSE187    BEGIN188      EXEC QBM_PJobCreate_HOUpdate @objecttype,189        @whereclause,190        @GenProcID,191        @AdditionalObjectKeysAffected,192        @p1,193        @v1,194        @p2,195        @v2,196        @p3,197        @v3,198        @p4,199        @v4,200        @p5,201        @v5,202        @p6,203        @v6,204        @p7,205        @v7,206        @p8,207        @v8,208        @p9,209        @v9,210        @p10,211        @v10,212        @p11,213        @v11,214        @p12,215        @v12,216        @p13,217        @v13,218        @p14,219        @v14,220        @p15,221        @v15,222        @p16,223        @v16,224        @p17,225        @v17,226        @p18,227        @v18,228        @p19,229        @v19,230        @p20,231        @v20,232        @p21,233        @v21,234        @p22,235        @v22,236        @p23,237        @v23,238        @p24,239        @v24,240        @p25,241        @v25,242        @p26,243        @v26,244        @p27,245        @v27,246        @p28,247        @v28,248        @p29,249        @v29,250        @p30,251        @v30,252        @p31,253        @v31,254        @isToFreezeOnError,255        @Retries,256        @priority,257        @Jobchainname,258        @StartAt,259        @BasisObjectKey,260        @XUser,261        @WhereClauseAdditional,262        @checkForExisting,263        @QueueName264    END265  END TRY266  BEGIN CATCH267    EXEC QBM_PSessionErrorAdd DEFAULT268    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()269    RAISERROR(@Rethrow,270    18,271    1)272      WITH NOWAIT273  END CATCH274  ende:275  RETURN276END
Open raw exported source
SQL ยท Raw35 lines
1  create   procedure QBM_PJobCreate_HOUpdate_B( @objecttype nvarchar(255),  @whereclause nvarchar(max),  @GenProcID varchar(38) , @AdditionalObjectKeysAffected2 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 @XObjectKeysToTransfer QBM_YParameterList declare @SQLCmd nvarchar(max)  SET XACT_ABORT OFF BEGIN TRY if exists17 (select top 1 1 from DialogTable t with (readpast) join DialogColumn c with (readpast) on t.UID_DialogTable = c.UID_DialogTable where t.TableName = @objecttype18 and c.ColumnName = 'XObjectKey' ) begin select @SQLCmd = N'19	  select XObjectKey 20		from ' + @objecttype + N'21		where ( ' + @whereclause + N' )22		order by 1 '23 insert into @XObjectKeysToTransfer(Parameter1) exec sp_executeSQL @SQLCmd exec QBM_PJobCreate_HOUpdate_L @objecttype , @XObjectKeysToTransfer , @GenProcID24 , @AdditionalObjectKeysAffected , @ConnectionVariables , @AuthenticationString , @SingleTransaction , @p1 , @v1 , @p2 , @v2 , @p3 , @v3 , @p4 , @v4 , 25@p5 , @v5 , @p6 , @v6 , @p7 , @v7 , @p8 , @v8 , @p9 , @v9 , @p10 , @v10 , @p11 , @v11 , @p12 , @v12 , @p13 , @v13 , @p14 , @v14 , @p15 , @v15 , @p16 , 26@v16 , @p17 , @v17 , @p18 , @v18 , @p19 , @v19 , @p20 , @v20 , @p21 , @v21 , @p22 , @v22 , @p23 , @v23 , @p24 , @v24 , @p25 , @v25 , @p26 , @v26 , @p2727 , @v27 , @p28 , @v28 , @p29 , @v29 , @p30 , @v30 , @p31 , @v31 , @isToFreezeOnError , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey28 , @XUser , @WhereClauseAdditional , @checkForExisting , @QueueName end else begin exec QBM_PJobCreate_HOUpdate @objecttype , @whereclause , @GenProcID29 , @AdditionalObjectKeysAffected, @p1 , @v1 , @p2 , @v2 , @p3 , @v3 , @p4 , @v4 , @p5 , @v5 , @p6 , @v6 , @p7 , @v7 , @p8 , @v8 , @p9 , @v9 , @p10 , @v1030 , @p11 , @v11 , @p12 , @v12 , @p13 , @v13 , @p14 , @v14 , @p15 , @v15 , @p16 , @v16 , @p17 , @v17 , @p18 , @v18 , @p19 , @v19 , @p20 , @v20 , @p21 , @v2131 , @p22 , @v22 , @p23 , @v23 , @p24 , @v24 , @p25 , @v25 , @p26 , @v26 , @p27 , @v27 , @p28 , @v28 , @p29 , @v29 , @p30 , @v30 , @p31 , @v31 , @isToFreezeOnError32 , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @WhereClauseAdditional , @checkForExisting , @QueueName end END TRY BEGIN33 CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END 34CATCH ende: return end 35