Back to OIM Explorer

dbo.QBM_PJobCreate_HOTemplate_B

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 2.093 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_HOTemplate source text reference
  • references source dbo.QBM_PJobCreate_HOTemplate_L source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL96 lines
1CREATE PROCEDURE QBM_PJobCreate_HOTemplate_B(2  @objecttype nvarchar(255),3  @whereclause nvarchar(max),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 @XObjectKeysToTransfer QBM_YParameterList24  DECLARE @SQLCmd nvarchar(max)25  SET XACT_ABORT OFF26  BEGIN TRY27    IF EXISTS(28      SELECT TOP 1 129      FROM DialogTable t30      WITH(readpast)31    JOIN DialogColumn c32      WITH(readpast)33      ON t.UID_DialogTable = c.UID_DialogTable34    WHERE35      t.TableName = @objecttype AND c.ColumnName = 'XObjectKey')36    BEGIN37      SELECT38        @SQLCmd = N '39	  select XObjectKey 40		from ' + @objecttype + N '41		where ( ' + @whereclause + N ' )42		order by 1 '43      INSERT INTO @XObjectKeysToTransfer(Parameter1)44      EXEC sp_executeSQL @SQLCmd45      EXEC QBM_PJobCreate_HOTemplate_L @objecttype,46        @XObjectKeysToTransfer,47        @Columns,48        @GenProcID,49        @AdditionalObjectKeysAffected,50        @ConnectionVariables,51        @AuthenticationString,52        @SingleTransaction,53        @isToFreezeOnError,54        @Retries,55        @priority,56        @Jobchainname,57        @StartAt,58        @BasisObjectKey,59        @XUser,60        @WhereClauseAdditional,61        @checkForExisting,62        @QueueName63    END64    ELSE65    BEGIN66      EXEC QBM_PJobCreate_HOTemplate @objecttype,67        @whereclause,68        @Columns,69        @GenProcID,70        @AdditionalObjectKeysAffected,71        @ConnectionVariables,72        @AuthenticationString,73        @SingleTransaction,74        @isToFreezeOnError,75        @Retries,76        @priority,77        @Jobchainname,78        @StartAt,79        @BasisObjectKey,80        @XUser,81        @WhereClauseAdditional,82        @checkForExisting,83        @QueueName84    END85  END TRY86  BEGIN CATCH87    EXEC QBM_PSessionErrorAdd DEFAULT88    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()89    RAISERROR(@Rethrow,90    18,91    1)92      WITH NOWAIT93  END CATCH94  ende:95  RETURN96END
Open raw exported source
SQL ยท Raw19 lines
1  create   procedure QBM_PJobCreate_HOTemplate_B( @objecttype nvarchar(255),  @whereclause nvarchar(max)  , @Columns nvarchar(max)  , @GenProcID2 varchar(38) , @AdditionalObjectKeysAffected QBM_YParameterList readonly  , @ConnectionVariables nvarchar(max) = null , @AuthenticationString nvarchar(max3) = null , @SingleTransaction bit = 1  , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) = null , @StartAt4 datetime = null , @BasisObjectKey varchar(138) = N'' , @XUser nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = '' , @checkForExisting bit 5= 0 , @QueueName nvarchar(256) = null ) as begin declare @XObjectKeysToTransfer QBM_YParameterList declare @SQLCmd nvarchar(max)  SET XACT_ABORT OFF BEGIN6 TRY if exists (select top 1 1 from DialogTable t with (readpast) join DialogColumn c with (readpast) on t.UID_DialogTable = c.UID_DialogTable where t.TableName7 = @objecttype and c.ColumnName = 'XObjectKey' ) begin select @SQLCmd = N'8	  select XObjectKey 9		from ' + @objecttype + N'10		where ( ' + @whereclause11 + N' )12		order by 1 ' insert into @XObjectKeysToTransfer(Parameter1) exec sp_executeSQL @SQLCmd exec QBM_PJobCreate_HOTemplate_L @objecttype ,  @XObjectKeysToTransfer13 , @Columns , @GenProcID , @AdditionalObjectKeysAffected , @ConnectionVariables , @AuthenticationString , @SingleTransaction , @isToFreezeOnError , @Retries14 , @priority , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @WhereClauseAdditional , @checkForExisting , @QueueName end else begin exec QBM_PJobCreate_HOTemplate15 @objecttype ,  @whereclause , @Columns , @GenProcID , @AdditionalObjectKeysAffected , @ConnectionVariables , @AuthenticationString , @SingleTransaction16 , @isToFreezeOnError , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @WhereClauseAdditional , @checkForExisting , @QueueName17 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 118) WITH NOWAIT END CATCH ende: return end 19