Back to OIM Explorer

dbo.QBM_PJobCreate_HOInsert

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 4.041 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

  • No direct source references extracted.

Complete Source

SQL201 lines
1CREATE PROCEDURE QBM_PJobCreate_HOInsert(2  @objecttype nvarchar(255),3  @GenProcID varchar(38),4  @ObjectKeysAffected QBM_YParameterList READONLY,5  @ConnectionVariables nvarchar(max) = NULL,6  @AuthenticationString nvarchar(max) = NULL,7  @SingleTransaction BIT = 1,8  @p1 nvarchar(1024) = N '',9  @v1 nvarchar(max) = N '',10  @p2 nvarchar(1024) = N '',11  @v2 nvarchar(max) = N '',12  @p3 nvarchar(1024) = N '',13  @v3 nvarchar(max) = N '',14  @p4 nvarchar(1024) = N '',15  @v4 nvarchar(max) = N '',16  @p5 nvarchar(1024) = N '',17  @v5 nvarchar(max) = N '',18  @p6 nvarchar(1024) = N '',19  @v6 nvarchar(max) = N '',20  @p7 nvarchar(1024) = N '',21  @v7 nvarchar(max) = N '',22  @p8 nvarchar(1024) = N '',23  @v8 nvarchar(max) = N '',24  @p9 nvarchar(1024) = N '',25  @v9 nvarchar(max) = N '',26  @p10 nvarchar(1024) = N '',27  @v10 nvarchar(max) = N '',28  @p11 nvarchar(1024) = N '',29  @v11 nvarchar(max) = N '',30  @p12 nvarchar(1024) = N '',31  @v12 nvarchar(max) = N '',32  @p13 nvarchar(1024) = N '',33  @v13 nvarchar(max) = N '',34  @p14 nvarchar(1024) = N '',35  @v14 nvarchar(max) = N '',36  @p15 nvarchar(1024) = N '',37  @v15 nvarchar(max) = N '',38  @p16 nvarchar(1024) = N '',39  @v16 nvarchar(max) = N '',40  @p17 nvarchar(1024) = N '',41  @v17 nvarchar(max) = N '',42  @p18 nvarchar(1024) = N '',43  @v18 nvarchar(max) = N '',44  @p19 nvarchar(1024) = N '',45  @v19 nvarchar(max) = N '',46  @p20 nvarchar(1024) = N '',47  @v20 nvarchar(max) = N '',48  @p21 nvarchar(1024) = N '',49  @v21 nvarchar(max) = N '',50  @p22 nvarchar(1024) = N '',51  @v22 nvarchar(max) = N '',52  @p23 nvarchar(1024) = N '',53  @v23 nvarchar(max) = N '',54  @p24 nvarchar(1024) = N '',55  @v24 nvarchar(max) = N '',56  @p25 nvarchar(1024) = N '',57  @v25 nvarchar(max) = N '',58  @p26 nvarchar(1024) = N '',59  @v26 nvarchar(max) = N '',60  @p27 nvarchar(1024) = N '',61  @v27 nvarchar(max) = N '',62  @p28 nvarchar(1024) = N '',63  @v28 nvarchar(max) = N '',64  @p29 nvarchar(1024) = N '',65  @v29 nvarchar(max) = N '',66  @p30 nvarchar(1024) = N '',67  @v30 nvarchar(max) = N '',68  @p31 nvarchar(1024) = N '',69  @v31 nvarchar(max) = N '',70  @isToFreezeOnError BIT = 0,71  @Retries int = 0,72  @priority int = 5,73  @Jobchainname nvarchar(256) = NULL,74  @StartAt datetime = NULL,75  @BasisObjectKey varchar(138) = N '',76  @XUser nvarchar(64) = NULL,77  @QueueName nvarchar(256) = NULL78)79AS80BEGIN81  DECLARE @Parameters QBM_YParameterList82  DECLARE @JobChainNameAddOn nvarchar(256)83  SET XACT_ABORT OFF84  BEGIN TRY85    IF @Jobchainname IS NULL86    BEGIN87      SELECT @JobChainNameAddOn = ' handle object insert for object type ' + @objecttype88      SELECT @Jobchainname =dbo.QBM_FGIJobCreateName(@JobChainNameAddOn)89    END90    INSERT INTO @Parameters(Parameter1,91    ContentFull)92    VALUES('objecttype',93    @objecttype),94    (@p1,95    @v1),96    (@p2,97    @v2),98    (@p3,99    @v3),100    (@p4,101    @v4),102    (@p5,103    @v5),104    (@p6,105    @v6),106    (@p7,107    @v7),108    (@p8,109    @v8),110    (@p9,111    @v9),112    (@p10,113    @v10),114    (@p11,115    @v11),116    (@p12,117    @v12),118    (@p13,119    @v13),120    (@p14,121    @v14),122    (@p15,123    @v15),124    (@p16,125    @v16),126    (@p17,127    @v17),128    (@p18,129    @v18),130    (@p19,131    @v19),132    (@p20,133    @v20),134    (@p21,135    @v21),136    (@p22,137    @v22),138    (@p23,139    @v23),140    (@p24,141    @v24),142    (@p25,143    @v25),144    (@p26,145    @v26),146    (@p27,147    @v27),148    (@p28,149    @v28),150    (@p29,151    @v29),152    (@p30,153    @v30),154    (@p31,155    @v31)156    IF @ConnectionVariables > ' '157    BEGIN158      INSERT INTO @Parameters(Parameter1,159      ContentFull)160      VALUES('ConnectionVariables',161      @ConnectionVariables)162    END163    IF @AuthenticationString > ' '164    BEGIN165      INSERT INTO @Parameters(Parameter1,166      ContentFull)167      VALUES('AuthenticationString',168      @AuthenticationString)169    END170    IF @SingleTransaction = 0171    BEGIN172      INSERT INTO @Parameters(Parameter1,173      ContentFull)174      VALUES('SingleTransaction',175      'FALSE')176    END177    EXEC QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent',178    'Insert',179      @Parameters,180      @GenProcID,181      @ObjectKeysAffected,182      @isToFreezeOnError,183      @Retries,184      @priority,185      @Jobchainname,186      @StartAt,187      @BasisObjectKey,188      @XUser,189      @QueueName190  END TRY191  BEGIN CATCH192    EXEC QBM_PSessionErrorAdd DEFAULT193    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()194    RAISERROR(@Rethrow,195    18,196    1)197      WITH NOWAIT198  END CATCH199  ende:200  RETURN201END
Open raw exported source
SQL ยท Raw27 lines
1 create   procedure QBM_PJobCreate_HOInsert ( @objecttype nvarchar(255),  @GenProcID varchar(38) , @ObjectKeysAffected QBM_YParameterList readOnly2  , @ConnectionVariables nvarchar(max) = null , @AuthenticationString nvarchar(max) = null , @SingleTransaction bit = 1 , @p1 nvarchar (1024) = N'', @v13 nvarchar (max) = N'' , @p2 nvarchar (1024) = N'', @v2 nvarchar (max) = N'' , @p3 nvarchar (1024) = N'', @v3 nvarchar (max) = N'' , @p4 nvarchar (1024)4 = N'', @v4 nvarchar (max) = N'' , @p5 nvarchar (1024) = N'', @v5 nvarchar (max) = N'' , @p6 nvarchar (1024) = N'', @v6 nvarchar (max) = N'' , @p7 nvarchar5 (1024) = N'', @v7 nvarchar (max) = N'' , @p8 nvarchar (1024) = N'', @v8 nvarchar (max) = N'' , @p9 nvarchar (1024) = N'', @v9 nvarchar (max) = N'' , @p106 nvarchar (1024) = N'', @v10 nvarchar (max) = N'' , @p11 nvarchar (1024) = N'', @v11 nvarchar (max) = N'' , @p12 nvarchar (1024) = N'', @v12 nvarchar (max7) = N'' , @p13 nvarchar (1024) = N'', @v13 nvarchar (max) = N'' , @p14 nvarchar (1024) = N'', @v14 nvarchar (max) = N'' , @p15 nvarchar (1024) = N'', @v158 nvarchar (max) = N'' , @p16 nvarchar (1024) = N'', @v16 nvarchar (max) = N'' , @p17 nvarchar (1024) = N'', @v17 nvarchar (max) = N'' , @p18 nvarchar (10249) = N'', @v18 nvarchar (max) = N'' , @p19 nvarchar (1024) = N'', @v19 nvarchar (max) = N'' , @p20 nvarchar (1024) = N'', @v20 nvarchar (max) = N'' , @p2110 nvarchar (1024) = N'', @v21 nvarchar (max) = N'' , @p22 nvarchar (1024) = N'', @v22 nvarchar (max) = N'' , @p23 nvarchar (1024) = N'', @v23 nvarchar (max11) = N'' , @p24 nvarchar (1024) = N'', @v24 nvarchar (max) = N'' , @p25 nvarchar (1024) = N'', @v25 nvarchar (max) = N'' , @p26 nvarchar (1024) = N'', @v2612 nvarchar (max) = N'' , @p27 nvarchar (1024) = N'', @v27 nvarchar (max) = N'' , @p28 nvarchar (1024) = N'', @v28 nvarchar (max) = N'' , @p29 nvarchar (102413) = N'', @v29 nvarchar (max) = N'' , @p30 nvarchar (1024) = N'', @v30 nvarchar (max) = N'' , @p31 nvarchar (1024) = N'', @v31 nvarchar (max) = N''  , @isToFreezeOnError14 bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) = null , @StartAt datetime = null , @BasisObjectKey varchar(138) = N'' , 15@XUser nvarchar(64) = null , @QueueName nvarchar(256) = null ) as begin declare @Parameters QBM_YParameterList declare @JobChainNameAddOn nvarchar(256)16 SET XACT_ABORT OFF BEGIN TRY if @Jobchainname is null begin select @JobChainNameAddOn = ' handle object insert for object type ' + @objecttype select 17@Jobchainname =dbo.QBM_FGIJobCreateName ( @JobChainNameAddOn) end insert into @Parameters (Parameter1, ContentFull) values ('objecttype', @objecttype) 18, ( @p1 , @v1 ) , ( @p2 , @v2 ) , ( @p3 , @v3 ) , ( @p4 , @v4 ) , ( @p5 , @v5 ) , ( @p6 , @v6 ) , ( @p7 , @v7 ) , ( @p8 , @v8 ) , ( @p9 , @v9 ) , ( @p1019 , @v10 ) , ( @p11 , @v11 ) , ( @p12 , @v12 ) , ( @p13 , @v13 ) , ( @p14 , @v14 ) , ( @p15 , @v15 ) , ( @p16 , @v16 ) , ( @p17 , @v17 ) , ( @p18 , @v1820 ) , ( @p19 , @v19 ) , ( @p20 , @v20 ) , ( @p21 , @v21 ) , ( @p22 , @v22 ) , ( @p23 , @v23 ) , ( @p24 , @v24 ) , ( @p25 , @v25 ) , ( @p26 , @v26 ) , ( 21@p27 , @v27 ) , ( @p28 , @v28 ) , ( @p29 , @v29 ) , ( @p30 , @v30 ) , ( @p31 , @v31 ) if @ConnectionVariables > ' ' begin insert into @Parameters(Parameter122, ContentFull) values ('ConnectionVariables', @ConnectionVariables) end if @AuthenticationString > ' ' begin insert into @Parameters(Parameter1, ContentFull23) values ('AuthenticationString', @AuthenticationString) end if @SingleTransaction = 0 begin insert into @Parameters(Parameter1, ContentFull) values ('SingleTransaction'24, 'FALSE') end exec QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent' , 'Insert' , @Parameters , @GenProcID , @ObjectKeysAffected , @isToFreezeOnError25 , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @QueueName END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare26 @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 27