Back to OIM Explorer

dbo.QBM_PDCB6A2129D7D15765BA077A_

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

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

References

Referenced By

Complete Source

SQL85 lines
1CREATE PROCEDURE QBM_PDCB6A2129D7D15765BA077A_(2  @Portion int,3  @AllObjectKeysIn QBM_YObjectKeyAndPortion READONLY,4  @TableToDelete varchar(30),5  @GenProcID varchar(38),6  @AdditionalObjectKeysAffected QBM_YParameterList READONLY,7  @isToFreezeOnError BIT = 0,8  @Retries int = 0,9  @priority int = 5,10  @Jobchainname nvarchar(256) = NULL,11  @StartAt datetime = NULL,12  @BasisObjectKey varchar(138) = N '',13  @XUser nvarchar(64) = NULL,14  @WhereClauseAdditional nvarchar(max) = '',15  @checkForExisting BIT = 0,16  @QueueName nvarchar(256) = NULL17)18AS19BEGIN20  DECLARE @ObjectKeys_Part QBM_YParameterList21  DECLARE @Sammler nvarchar(max)22  DECLARE @ObjectKeysAffected QBM_YParameterList23  SET XACT_ABORT OFF24  BEGIN TRY25    INSERT INTO @ObjectKeys_Part(Parameter1)26    SELECT i.Objectkey27    FROM @AllObjectKeysIn i28    WHERE29      i.Portion = @Portion30    IF @@ROWCOUNT = 031    BEGIN32      GOTO endLabel33    END34    SELECT35      @sammler = CONCAT('XObjectKey in ',36      dbo.QBM_FCVParameter1AsOneInClause(@ObjectKeys_Part))37    IF NOT EXISTS(38      SELECT TOP 1 139      FROM @AdditionalObjectKeysAffected40      WHERE41        Parameter1 > ' ' AND Parameter2 IS NULL)42    BEGIN43      INSERT INTO @ObjectKeysAffected(Parameter1)44      SELECT a.Parameter145      FROM @AdditionalObjectKeysAffected a46      JOIN @ObjectKeys_Part s47        ON a.Parameter2 = s.Parameter148      UNION49      SELECT Parameter150      FROM @ObjectKeys_Part51    END52    ELSE53    BEGIN54      INSERT INTO @ObjectKeysAffected(Parameter1)55      SELECT a.Parameter156      FROM @AdditionalObjectKeysAffected a57      UNION58      SELECT Parameter159      FROM @ObjectKeys_Part60    END61    EXEC QBM_PJobCreate_SQLDel @TableToDelete,62      @Sammler,63      @GenProcID,64      @ObjectKeysAffected,65      @isToFreezeOnError,66      @Retries,67      @priority,68      @Jobchainname,69      @StartAt,70      @BasisObjectKey,71      @XUser,72      @WhereClauseAdditional,73      @checkForExisting,74      @QueueName75  END TRY76  BEGIN CATCH77    EXEC QBM_PSessionErrorAdd DEFAULT78    RAISERROR('',79    18,80    1)81      WITH NOWAIT82  END CATCH83  endLabel:84  RETURN85END
Open raw exported source
SQL ยท Raw13 lines
1create   procedure QBM_PDCB6A2129D7D15765BA077A_ (@Portion int , @AllObjectKeysIn QBM_YObjectKeyAndPortion readonly  , @TableToDelete varchar (302)     , @GenProcID varchar(38) , @AdditionalObjectKeysAffected QBM_YParameterList readOnly    , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority3 int = 5 , @Jobchainname nvarchar(256) = null , @StartAt datetime = null , @BasisObjectKey varchar(138) = N'' , @XUser nvarchar(64) = null , @WhereClauseAdditional4 nvarchar(max) = '' , @checkForExisting bit = 0 , @QueueName nvarchar(256) = null ) as begin declare @ObjectKeys_Part QBM_YParameterList declare @Sammler5 nvarchar(max) declare @ObjectKeysAffected QBM_YParameterList SET XACT_ABORT OFF BEGIN TRY insert into @ObjectKeys_Part(Parameter1) select i.Objectkey 6from @AllObjectKeysIn i where i.Portion = @Portion if @@ROWCOUNT = 0 begin goto endLabel end select @sammler = concat('XObjectKey in ' , dbo.QBM_FCVParameter1AsOneInClause7(@ObjectKeys_Part) )  if not exists (select top 1 1 from @AdditionalObjectKeysAffected where Parameter1 > ' ' and Parameter2 is null ) begin insert into8 @ObjectKeysAffected(Parameter1) select a.Parameter1 from @AdditionalObjectKeysAffected a join @ObjectKeys_Part s on a.Parameter2 = s.Parameter1 union 9select Parameter1 from @ObjectKeys_Part end else begin  insert into @ObjectKeysAffected(Parameter1) select a.Parameter1 from @AdditionalObjectKeysAffected10 a union select Parameter1 from @ObjectKeys_Part end exec QBM_PJobCreate_SQLDel @TableToDelete , @Sammler , @GenProcID , @ObjectKeysAffected , @isToFreezeOnError11 , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @WhereClauseAdditional , @checkForExisting , @QueueName END TRY BEGIN CATCH12 exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 13