Back to OIM Explorer

dbo.QBM_P5C881179A5B9B0CDCAE541D_

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

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

References

Referenced By

Complete Source

SQL93 lines
1CREATE PROCEDURE QBM_P5C881179A5B9B0CDCAE541D_(2  @Portion int,3  @AllObjectKeysIn QBM_YObjectKeyAndPortion READONLY,4  @objecttype nvarchar(255),5  @Columns nvarchar(max),6  @GenProcID varchar(38),7  @AdditionalObjectKeysAffected QBM_YParameterList READONLY,8  @ConnectionVariables nvarchar(max) = NULL,9  @AuthenticationString nvarchar(max) = NULL,10  @SingleTransaction BIT = 1,11  @isToFreezeOnError BIT = 0,12  @Retries int = 0,13  @priority int = 5,14  @Jobchainname nvarchar(256) = NULL,15  @StartAt datetime = NULL,16  @BasisObjectKey varchar(138) = N '',17  @XUser nvarchar(64) = NULL,18  @WhereClauseAdditional nvarchar(max) = '',19  @checkForExisting BIT = 0,20  @QueueName nvarchar(256) = NULL21)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_HOTemplate @objecttype,66      @Sammler,67      @Columns,68      @GenProcID,69      @ObjectKeysAffected,70      @ConnectionVariables,71      @AuthenticationString,72      @SingleTransaction,73      @isToFreezeOnError,74      @Retries,75      @priority,76      @Jobchainname,77      @StartAt,78      @BasisObjectKey,79      @XUser,80      @WhereClauseAdditional,81      @checkForExisting,82      @QueueName83  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_P5C881179A5B9B0CDCAE541D_( @Portion int , @AllObjectKeysIn QBM_YObjectKeyAndPortion readonly  , @objecttype nvarchar(255)2      , @Columns nvarchar(max)  , @GenProcID varchar(38) , @AdditionalObjectKeysAffected QBM_YParameterList readonly    , @ConnectionVariables nvarchar3(max) = null , @AuthenticationString nvarchar(max) = null , @SingleTransaction bit = 1  , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int4 = 5 , @Jobchainname nvarchar(256) = null , @StartAt datetime = null , @BasisObjectKey varchar(138) = N'' , @XUser nvarchar(64) = null , @WhereClauseAdditional5 nvarchar(max) = '' , @checkForExisting bit = 0 , @QueueName nvarchar(256) = null ) as begin declare @ObjectKeys_Part QBM_YParameterList declare @Sammler6 nvarchar(max) declare @ObjectKeysAffected QBM_YParameterList SET XACT_ABORT OFF BEGIN TRY insert into @ObjectKeys_Part(Parameter1) select i.Objectkey 7from @AllObjectKeysIn i where i.Portion = @Portion if @@ROWCOUNT = 0 begin goto endLabel end select @sammler = concat('XObjectKey in ' , dbo.QBM_FCVParameter1AsOneInClause8(@ObjectKeys_Part) )  if not exists (select top 1 1 from @AdditionalObjectKeysAffected where Parameter1 > ' ' and Parameter2 is null ) begin insert into9 @ObjectKeysAffected(Parameter1) select a.Parameter1 from @AdditionalObjectKeysAffected a join @ObjectKeys_Part s on a.Parameter2 = s.Parameter1 union 10select Parameter1 from @ObjectKeys_Part end else begin  insert into @ObjectKeysAffected(Parameter1) select a.Parameter1 from @AdditionalObjectKeysAffected11 a union select Parameter1 from @ObjectKeys_Part end exec QBM_PJobCreate_HOTemplate @objecttype , @Sammler , @Columns , @GenProcID , @ObjectKeysAffected12 , @ConnectionVariables , @AuthenticationString , @SingleTransaction , @isToFreezeOnError , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey13 , @XUser , @WhereClauseAdditional , @checkForExisting , @QueueName END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT14 END CATCH endLabel: return end 15