Back to OIM Explorer

dbo.QER_ZBaseTreeHasObjectExtAtt

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.860 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_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 source dbo.QER_ZBaseTreeHasObject source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL87 lines
1CREATE PROCEDURE QER_ZBaseTreeHasObjectExtAtt(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>ExtendedAttribute</T>%'46    INSERT INTO @SourceData(IsUpcommingContent,47    XOriginBefore,48    Element,49    AssignedElement,50    XOriginAfter)51    SELECT52      1,53      0,54      y.UID_Org,55      ea.XObjectKey,56      @QER_BitPattern_Inherit_057    FROM BaseTreeHasObject y58    JOIN @DBQueueCurrent x59      ON y.UID_Org= x.uid_parameter60    JOIN ObjectHasExtendedAttribute oha61      ON oha.ObjectKeyOfObject = y.ObjectKey62    JOIN ExtendedAttribute ea63      ON oha.UID_ExtendedAttribute = ea.UID_ExtendedAttribute64    WHERE65      y.ObjectKey NOT LIKE '<Key><T>ExtendedAttribute</T>%' berechnen:66    EXEC QBM_PDBQueueCalculateDelta @SourceData,67      @DeltaQuantity = 0,68      @DeltaDelete = 1,69      @DeltaInsert = 1,70      @DeltaOrigin = 1,71      @CountDeltaQantity = @CountDeltaQantity OUTPUT,72      @CountDeltaOrigin = @CountDeltaOrigin OUTPUT,73      @UseIsInEffect = 0,74      @SlotNumber = @SlotNumber,75      @DBQueueCurrentExtern = @DBQueueCurrent76    EXEC QER_PBasetreeHasObjectPostProc @CountDeltaOrigin,77      @CountDeltaQantity78  END TRY79  BEGIN CATCH80    EXEC QBM_PSessionErrorAdd DEFAULT81    RAISERROR('',82    18,83    1)84      WITH NOWAIT85  END CATCH86  endLabel:87END
Open raw exported source
SQL ยท Raw13 lines
1   create   procedure QER_ZBaseTreeHasObjectExtAtt (@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>ExtendedAttribute</T>%'  insert into @SourceData( IsUpcommingContent, XOriginBefore ,7 Element, AssignedElement, XOriginAfter ) select 1, 0 , y.UID_Org, ea.XObjectKey, @QER_BitPattern_Inherit_0 from BaseTreeHasObject y join @DBQueueCurrent8 x on y.UID_Org= x.uid_parameter join ObjectHasExtendedAttribute oha on oha.ObjectKeyOfObject = y.ObjectKey join ExtendedAttribute ea on oha.UID_ExtendedAttribute9 = ea.UID_ExtendedAttribute where y.ObjectKey not like '<Key><T>ExtendedAttribute</T>%' berechnen: exec QBM_PDBQueueCalculateDelta @SourceData, @DeltaQuantity10 = 0, @DeltaDelete = 1, @DeltaInsert = 1, @DeltaOrigin = 1, @CountDeltaQantity = @CountDeltaQantity output , @CountDeltaOrigin = @CountDeltaOrigin output11 , @UseIsInEffect = 0 , @SlotNumber = @SlotNumber , @DBQueueCurrentExtern = @DBQueueCurrent exec QER_PBasetreeHasObjectPostProc @CountDeltaOrigin, @CountDeltaQantity12 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: end 13