Back to OIM Explorer

dbo.TSB_ZBaseTreeOwnsObjectPrepair

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 6; References QBM_PDBQueueInsert_Single

Source: sandbox-db sys.sql_modules

Source size: 1.078 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 6
  • References QBM_PDBQueueInsert_Single

Typed Edges

  • queues DBQueue task QBM_ZRecalculate at line 6 Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 6
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.TSB_ZBaseTreeOwnsObject source text reference
  • queues DBQueue task QBM-K-CommonReCalculate -> QBM_ZRecalculate QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'TSB-K-BaseTreeOwnsObject' , '', @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: end

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL55 lines
1CREATE PROCEDURE TSB_ZBaseTreeOwnsObjectPrepair(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @MyName nvarchar(64) = object_name(@@procid)7  DECLARE @GenProcID varchar(38)8  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent9  BEGIN TRY10    INSERT INTO @DBQueueCurrent(UID_DialogDBQueue,11    UID_Parameter,12    UID_SubParameter,13    GenProcID)14    SELECT15      UID_DialogDBQueue,16      UID_Parameter,17      UID_SubParameter,18      GenProcID19    FROM QBMDBQueueCurrent cu20      WITH(readpast)21    WHERE22      cu.SlotNumber = @SlotNumber23    IF @@rowcount = 024    BEGIN25      GOTO EndLabel26    END27    IF EXISTS(28      SELECT TOP 1 129      FROM @DBQueueCurrent c30      JOIN BaseTreeCollectionF b31        ON c.UID_Parameter = b.UID_Org32      WHERE33        b.UID_ParentOrg = 'TSB-AEROLE-NAMESPACEADMIN-UNSB')34    BEGIN35      SELECT TOP 1 @GenProcID = c.GenProcID36      FROM @DBQueueCurrent c37      JOIN BaseTreeCollectionF b38        ON c.UID_Parameter = b.UID_Org39      WHERE40        b.UID_ParentOrg = 'TSB-AEROLE-NAMESPACEADMIN-UNSB'41      EXEC QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate',42      'TSB-K-BaseTreeOwnsObject',43      '',44        @GenProcID45    END46  END TRY47  BEGIN CATCH48    EXEC QBM_PSessionErrorAdd DEFAULT49    RAISERROR('',50    18,51    1)52      WITH NOWAIT53  END CATCH54  endLabel:55END
Open raw exported source
SQL ยท Raw8 lines
1      create   procedure TSB_ZBaseTreeOwnsObjectPrepair (@SlotNumber int) AS begin declare @MyName nvarchar(64) = object_name(@@procid) declare 2@GenProcID varchar(38) declare @DBQueueCurrent QBM_YDBQueueCurrent BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter3, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber4 if @@rowcount = 0 begin goto EndLabel end if exists (select top 1 1 from @DBQueueCurrent c join BaseTreeCollectionF b on c.UID_Parameter = b.UID_Org where5 b.UID_ParentOrg = 'TSB-AEROLE-NAMESPACEADMIN-UNSB' ) begin select top 1 @GenProcID = c.GenProcID from @DBQueueCurrent c join BaseTreeCollectionF b on 6c.UID_Parameter = b.UID_Org where b.UID_ParentOrg = 'TSB-AEROLE-NAMESPACEADMIN-UNSB' exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'TSB-K-BaseTreeOwnsObject'7, '', @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: end 8