Back to OIM Explorer

dbo.RMS_ZBaseTreeHasObject

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.720 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QER_FCVXOriginToInheritInfo source text reference
  • references source dbo.QER_FGIBitPatternInheritInfo source text reference
  • references source dbo.QBM_PDBQueueCalculateDelta source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QER_PBasetreeHasObjectPostProc source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL83 lines
1CREATE PROCEDURE RMS_ZBaseTreeHasObject(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @Sourcedata QBM_YDataForDelta,7  @CountDeltaQantity int,8  @CountDeltaOrigin int9  DECLARE @QER_BitPattern_Inherit_0 int = dbo.QER_FGIBitPatternInheritInfo('|Inherit|',10  0)11  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent12  BEGIN TRY13    INSERT INTO @DBQueueCurrent(UID_DialogDBQueue,14    UID_Parameter,15    UID_SubParameter,16    GenProcID)17    SELECT18      UID_DialogDBQueue,19      UID_Parameter,20      UID_SubParameter,21      GenProcID22    FROM QBMDBQueueCurrent cu23      WITH(readpast)24    WHERE25      cu.SlotNumber = @SlotNumber26    IF @@rowcount = 027    BEGIN28      GOTO EndLabel29    END30    INSERT INTO @SourceData(IsUpcommingContent,31    XOriginAfter,32    Element,33    AssignedElement,34    XOriginBefore)35    SELECT36      0,37      0,38      uid_Org,39      ObjectKey,40      InheritInfo41    FROM BaseTreeHasObject bho42    JOIN @DBQueueCurrent x43      ON uid_Org = x.uid_parameter44    WHERE45      bho.ObjectKey LIKE '<Key><T>ESet</T>%'46    INSERT INTO @SourceData(IsUpcommingContent,47    XOriginBefore,48    Element,49    AssignedElement,50    XOriginAfter)51    SELECT52      1,53      0,54      y.UID_Org,55      z.XObjectKey,56      dbo.QER_FCVXOriginToInheritInfo(y.XOrigin)57    FROM BaseTreeHasESet y58    JOIN @DBQueueCurrent x59      ON y.UID_Org= x.uid_parameter AND y.XOrigin > 0 AND y.XIsInEffect = 160    JOIN ESet z61      ON z.uid_ESet = y.uid_ESet berechnen:62    EXEC QBM_PDBQueueCalculateDelta @SourceData,63      @DeltaQuantity = 0,64      @DeltaDelete = 1,65      @DeltaInsert = 1,66      @DeltaOrigin = 1,67      @CountDeltaQantity = @CountDeltaQantity OUTPUT,68      @CountDeltaOrigin = @CountDeltaOrigin OUTPUT,69      @UseIsInEffect = 0,70      @SlotNumber = @SlotNumber,71      @DBQueueCurrentExtern = @DBQueueCurrent72    EXEC QER_PBasetreeHasObjectPostProc @CountDeltaOrigin,73      @CountDeltaQantity74  END TRY75  BEGIN CATCH76    EXEC QBM_PSessionErrorAdd DEFAULT77    RAISERROR('',78    18,79    1)80      WITH NOWAIT81  END CATCH82  endLabel:83END
Open raw exported source
SQL ยท Raw12 lines
1      create   procedure RMS_ZBaseTreeHasObject (@SlotNumber int) AS begin declare @Sourcedata QBM_YDataForDelta , @CountDeltaQantity int , @CountDeltaOrigin2 int declare @QER_BitPattern_Inherit_0 int = dbo.QER_FGIBitPatternInheritInfo('|Inherit|', 0) declare @DBQueueCurrent QBM_YDBQueueCurrent BEGIN TRY insert3 into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID4 from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end insert into @SourceData( IsUpcommingContent5, XOriginAfter , Element, AssignedElement, XOriginBefore ) select 0, 0 , uid_Org, ObjectKey, InheritInfo from BaseTreeHasObject bho join @DBQueueCurrent6 x on uid_Org = x.uid_parameter where bho.ObjectKey like '<Key><T>ESet</T>%'  insert into @SourceData( IsUpcommingContent, XOriginBefore , Element, AssignedElement7, XOriginAfter ) select 1, 0 , y.UID_Org, z.XObjectKey, dbo.QER_FCVXOriginToInheritInfo(y.XOrigin) from BaseTreeHasESet y join @DBQueueCurrent x on y.UID_Org=8 x.uid_parameter and y.XOrigin > 0 and y.XIsInEffect = 1 join ESet z on z.uid_ESet = y.uid_ESet   berechnen: exec QBM_PDBQueueCalculateDelta @SourceData9, @DeltaQuantity = 0, @DeltaDelete = 1, @DeltaInsert = 1, @DeltaOrigin = 1, @CountDeltaQantity = @CountDeltaQantity output , @CountDeltaOrigin = @CountDeltaOrigin10 output , @UseIsInEffect = 0 , @SlotNumber = @SlotNumber , @DBQueueCurrentExtern = @DBQueueCurrent exec QER_PBasetreeHasObjectPostProc @CountDeltaOrigin11, @CountDeltaQantity END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: end 12