Back to OIM Explorer

dbo.QBM_PJobCreate_HODelete_B

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 2.430 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_HODelete source text reference
  • references source dbo.QBM_PJobCreate_HODelete_L source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL96 lines
1CREATE PROCEDURE QBM_PJobCreate_HODelete_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  @isToFreezeOnError BIT = 0,10  @Retries int = 0,11  @priority int = 5,12  @Jobchainname nvarchar(256) = NULL,13  @StartAt datetime = NULL,14  @BasisObjectKey varchar(138) = '',15  @XUser nvarchar(64) = NULL,16  @WhereClauseAdditional nvarchar(max) = '',17  @checkForExisting BIT = 0,18  @QueueName nvarchar(256) = NULL,19  @DeepDelete BIT = 020)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_HODelete_L @objecttype,46        @XObjectKeysToTransfer,47        @GenProcID,48        @AdditionalObjectKeysAffected,49        @ConnectionVariables,50        @AuthenticationString,51        @SingleTransaction,52        @isToFreezeOnError = @isToFreezeOnError,53        @Retries = @Retries,54        @priority = @priority,55        @Jobchainname = @Jobchainname,56        @StartAt = @StartAt,57        @BasisObjectKey = @BasisObjectKey,58        @XUser = @XUser,59        @WhereClauseAdditional = @WhereClauseAdditional,60        @checkForExisting = @checkForExisting,61        @QueueName = @QueueName,62        @DeepDelete = @DeepDelete63    END64    ELSE65    BEGIN66      EXEC QBM_PJobCreate_HODelete @objecttype,67        @whereclause,68        @GenProcID,69        @AdditionalObjectKeysAffected,70        @ConnectionVariables,71        @AuthenticationString,72        @SingleTransaction,73        @isToFreezeOnError = @isToFreezeOnError,74        @Retries = @Retries,75        @priority = @priority,76        @Jobchainname = @Jobchainname,77        @StartAt = @StartAt,78        @BasisObjectKey = @BasisObjectKey,79        @XUser = @XUser,80        @WhereClauseAdditional = @WhereClauseAdditional,81        @checkForExisting = @checkForExisting,82        @QueueName = @QueueName,83        @DeepDelete = @DeepDelete84    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 ยท Raw21 lines
1  create   procedure QBM_PJobCreate_HODelete_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 , @isToFreezeOnError3 bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) = null , @StartAt datetime = null , @BasisObjectKey varchar(138) = '' , @XUser4 nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = '' , @checkForExisting bit = 0 , @QueueName nvarchar(256) = null , @DeepDelete bit = 0  )5 as begin declare @XObjectKeysToTransfer QBM_YParameterList declare @SQLCmd nvarchar(max)  SET XACT_ABORT OFF BEGIN TRY if exists (select top 1 1 from 6DialogTable t with (readpast) join DialogColumn c with (readpast) on t.UID_DialogTable = c.UID_DialogTable where t.TableName = @objecttype and c.ColumnName7 = 'XObjectKey' ) begin select @SQLCmd = N'8	  select XObjectKey 9		from ' + @objecttype + N'10		where ( ' + @whereclause + N' )11		order by 1 ' insert12 into @XObjectKeysToTransfer(Parameter1) exec sp_executeSQL @SQLCmd exec QBM_PJobCreate_HODelete_L @objecttype , @XObjectKeysToTransfer , @GenProcID , 13@AdditionalObjectKeysAffected , @ConnectionVariables , @AuthenticationString , @SingleTransaction , @isToFreezeOnError = @isToFreezeOnError , @Retries 14= @Retries , @priority = @priority , @Jobchainname = @Jobchainname , @StartAt = @StartAt , @BasisObjectKey = @BasisObjectKey , @XUser = @XUser , @WhereClauseAdditional15 = @WhereClauseAdditional , @checkForExisting = @checkForExisting , @QueueName = @QueueName , @DeepDelete = @DeepDelete end else begin exec QBM_PJobCreate_HODelete16 @objecttype , @whereclause , @GenProcID , @AdditionalObjectKeysAffected , @ConnectionVariables , @AuthenticationString , @SingleTransaction , @isToFreezeOnError17 = @isToFreezeOnError , @Retries = @Retries , @priority = @priority , @Jobchainname = @Jobchainname , @StartAt = @StartAt , @BasisObjectKey = @BasisObjectKey18 , @XUser = @XUser , @WhereClauseAdditional = @WhereClauseAdditional , @checkForExisting = @checkForExisting , @QueueName = @QueueName , @DeepDelete = 19@DeepDelete end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow20, 18, 1) WITH NOWAIT END CATCH ende: return end 21