Back to OIM Explorer

dbo.QBM_PB3D180A1745C229E35DBD6E_

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 2.068 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_FCVParameter1AsOneInClause source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HODelete source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL93 lines
1CREATE PROCEDURE QBM_PB3D180A1745C229E35DBD6E_(2  @Portion int,3  @AllObjectKeysIn QBM_YObjectKeyAndPortion READONLY,4  @objecttype nvarchar(255),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) = '',16  @XUser nvarchar(64) = NULL,17  @WhereClauseAdditional nvarchar(max) = '',18  @checkForExisting BIT = 0,19  @QueueName nvarchar(256) = NULL,20  @DeepDelete BIT = 021)22AS23BEGIN24  DECLARE @ObjectKeys_Part QBM_YParameterList25  DECLARE @Sammler nvarchar(max)26  DECLARE @ObjectKeysAffected QBM_YParameterList27  SET XACT_ABORT OFF28  BEGIN TRY29    INSERT INTO @ObjectKeys_Part(Parameter1)30    SELECT i.Objectkey31    FROM @AllObjectKeysIn i32    WHERE33      i.Portion = @Portion34    IF @@ROWCOUNT = 035    BEGIN36      GOTO endLabel37    END38    SELECT39      @sammler = CONCAT('XObjectKey in ',40      dbo.QBM_FCVParameter1AsOneInClause(@ObjectKeys_Part))41    IF NOT EXISTS(42      SELECT TOP 1 143      FROM @AdditionalObjectKeysAffected44      WHERE45        Parameter1 > ' ' AND Parameter2 IS NULL)46    BEGIN47      INSERT INTO @ObjectKeysAffected(Parameter1)48      SELECT a.Parameter149      FROM @AdditionalObjectKeysAffected a50      JOIN @ObjectKeys_Part s51        ON a.Parameter2 = s.Parameter152      UNION53      SELECT Parameter154      FROM @ObjectKeys_Part55    END56    ELSE57    BEGIN58      INSERT INTO @ObjectKeysAffected(Parameter1)59      SELECT a.Parameter160      FROM @AdditionalObjectKeysAffected a61      UNION62      SELECT Parameter163      FROM @ObjectKeys_Part64    END65    EXEC QBM_PJobCreate_HODelete @objecttype,66      @Sammler,67      @GenProcID,68      @ObjectKeysAffected,69      @ConnectionVariables,70      @AuthenticationString,71      @SingleTransaction,72      @isToFreezeOnError,73      @Retries,74      @priority,75      @Jobchainname,76      @StartAt,77      @BasisObjectKey,78      @XUser,79      @WhereClauseAdditional,80      @checkForExisting,81      @QueueName,82      @DeepDelete = @DeepDelete83  END TRY84  BEGIN CATCH85    EXEC QBM_PSessionErrorAdd DEFAULT86    RAISERROR('',87    18,88    1)89      WITH NOWAIT90  END CATCH91  endLabel:92  RETURN93END
Open raw exported source
SQL ยท Raw15 lines
1create   procedure QBM_PB3D180A1745C229E35DBD6E_( @Portion int , @AllObjectKeysIn QBM_YObjectKeyAndPortion readonly  , @objecttype nvarchar(255)2   , @GenProcID varchar(38) , @AdditionalObjectKeysAffected QBM_YParameterList readonly    , @ConnectionVariables nvarchar(max) = null , @AuthenticationString3 nvarchar(max) = null , @SingleTransaction bit = 1 , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) = 4null , @StartAt datetime = null , @BasisObjectKey varchar(138) = '' , @XUser nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = '' , @checkForExisting5 bit = 0 , @QueueName nvarchar(256) = null , @DeepDelete bit = 0  ) as begin declare @ObjectKeys_Part QBM_YParameterList declare @Sammler nvarchar(max)6 declare @ObjectKeysAffected QBM_YParameterList SET XACT_ABORT OFF BEGIN TRY insert into @ObjectKeys_Part(Parameter1) select i.Objectkey from @AllObjectKeysIn7 i where i.Portion = @Portion if @@ROWCOUNT = 0 begin goto endLabel end select @sammler = concat('XObjectKey in ' , dbo.QBM_FCVParameter1AsOneInClause(@ObjectKeys_Part8) )  if not exists (select top 1 1 from @AdditionalObjectKeysAffected where Parameter1 > ' ' and Parameter2 is null ) begin insert into @ObjectKeysAffected9(Parameter1) select a.Parameter1 from @AdditionalObjectKeysAffected a join @ObjectKeys_Part s on a.Parameter2 = s.Parameter1 union select Parameter1 from10 @ObjectKeys_Part end else begin  insert into @ObjectKeysAffected(Parameter1) select a.Parameter1 from @AdditionalObjectKeysAffected a union select Parameter111 from @ObjectKeys_Part end exec QBM_PJobCreate_HODelete @objecttype , @Sammler , @GenProcID , @ObjectKeysAffected , @ConnectionVariables , @AuthenticationString12 , @SingleTransaction , @isToFreezeOnError , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @WhereClauseAdditional , @checkForExisting13 , @QueueName , @DeepDelete = @DeepDelete END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return14 end 15