Back to OIM Explorer

dbo.QBM_ZGroupNumber

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Single DBQueue insert -> QBM-K-CommonPrepropGroup / QBM_ZPrePropGroup at line 9; Single DBQueue insert -> QBM-K-CommonGroupCollection / QBM_ZGroupCollection at line 9; Single DBQueue insert -> QBM-K-CommonGroupPattern / QBM_ZGroupPattern at line 9; Single DBQueue insert -> QBM-K-CommonGroupPattern / QBM_ZGroupPattern at line 9

Source: sandbox-db sys.sql_modules

Source size: 2.230 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-CommonPrepropGroup / QBM_ZPrePropGroup at line 9
  • Single DBQueue insert -> QBM-K-CommonGroupCollection / QBM_ZGroupCollection at line 9
  • Single DBQueue insert -> QBM-K-CommonGroupPattern / QBM_ZGroupPattern at line 9
  • Single DBQueue insert -> QBM-K-CommonGroupPattern / QBM_ZGroupPattern at line 9
  • Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 9
  • Single DBQueue insert -> QBM-K-CommonGroupCollection / QBM_ZGroupCollection at line 10
  • Single DBQueue insert -> QBM-K-CommonGroupPattern / QBM_ZGroupPattern at line 10
  • Single DBQueue insert -> QBM-K-CommonGroupPattern / QBM_ZGroupPattern at line 10
  • Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 10
  • Single DBQueue insert -> QBM-K-CommonGroupPattern / QBM_ZGroupPattern at line 11
  • Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 11
  • Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 13
  • References QBM_PDBQueueInsert_Single

Typed Edges

  • queues DBQueue task QBM_ZPrePropGroup at line 9 Single DBQueue insert -> QBM-K-CommonPrepropGroup / QBM_ZPrePropGroup at line 9
  • queues DBQueue task QBM_ZGroupCollection at line 9 Single DBQueue insert -> QBM-K-CommonGroupCollection / QBM_ZGroupCollection at line 9
  • queues DBQueue task QBM_ZGroupPattern at line 9 Single DBQueue insert -> QBM-K-CommonGroupPattern / QBM_ZGroupPattern at line 9
  • queues DBQueue task QBM_ZRecalculate at line 9 Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 9
  • queues DBQueue task QBM_ZGroupCollection at line 10 Single DBQueue insert -> QBM-K-CommonGroupCollection / QBM_ZGroupCollection at line 10
  • queues DBQueue task QBM_ZGroupPattern at line 10 Single DBQueue insert -> QBM-K-CommonGroupPattern / QBM_ZGroupPattern at line 10
  • queues DBQueue task QBM_ZRecalculate at line 10 Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 10
  • queues DBQueue task QBM_ZGroupPattern at line 11 Single DBQueue insert -> QBM-K-CommonGroupPattern / QBM_ZGroupPattern at line 11
  • queues DBQueue task QBM_ZRecalculate at line 11 Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 11
  • queues DBQueue task QBM_ZRecalculate at line 13 Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 13
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PSessionContextSet source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task QBM-K-CommonPrepropGroup -> QBM_ZPrePropGroup QBM_PDBQueueInsert_Single 'QBM-K-CommonPrepropGroup' , @uid_dialogGroup, '', @GenProcID exec QBM_PDBQueueInsert_Single 'QBM-K-CommonGroupCollection', @uid_dialogGroup, '', @GenProcID exec QBM_PDBQueueInsert_Single 'QBM-K-CommonGroupPattern…
  • queues DBQueue task QBM-K-CommonGroupCollection -> QBM_ZGroupCollection QBM_PDBQueueInsert_Single 'QBM-K-CommonGroupCollection', @uid_dialogGroup, '', @GenProcID exec QBM_PDBQueueInsert_Single 'QBM-K-CommonGroupPattern', @uid_dialogGroup, '', @GenProcID end else begin exec QBM_PDBQueueInsert_Single 'QBM-K-Comm…
  • queues DBQueue task QBM-K-CommonGroupPattern -> QBM_ZGroupPattern QBM_PDBQueueInsert_Single 'QBM-K-CommonGroupPattern', @uid_dialogGroup, '', @GenProcID end else begin exec QBM_PDBQueueInsert_Single 'QBM-K-CommonGroupPattern', @uid_dialogGroup , '', @GenProcID end select @VectorLen_new = (isnull(max(isnu…
  • queues DBQueue task QBM-K-CommonReCalculate -> QBM_ZRecalculate QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QBM-K-CommonGroupPattern' , '', @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: exec QBM_PSessionContextSet 'GenPr…

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL113 lines
1CREATE PROCEDURE QBM_ZGroupNumber(2  @SlotNumber int,3  @uid_dialogGroup varchar(38),4  @dummy2 varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @Groupnumber int10  DECLARE @neu int11  DECLARE @VectorLen_old int12  DECLARE @VectorLen_new int13  DECLARE @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('')14  BEGIN TRY15    IF NOT EXISTS(16      SELECT TOP 1 117      FROM DialogGroup18      WHERE19        uid_dialogGroup = @uid_dialogGroup)20    BEGIN21      GOTO ende22    END23    SELECT24      @VectorLen_old = max(isnull(datalength(GroupBitPattern), 0))25    FROM dialoggroup26    IF isnull(@VectorLen_old,27    0) < 3228    BEGIN29      SELECT @VectorLen_old = 3230    END31    SELECT TOP 1 @Groupnumber = Groupnumber32    FROM dialogGroup33    WHERE34      uid_dialogGroup = @uid_dialogGroup35    IF @Groupnumber IS NULL36    BEGIN37      SELECT @Groupnumber = 038    END39    IF @Groupnumber > 0 AND EXISTS(40      SELECT TOP 1 141      FROM dialogGroup42      WHERE43        uid_dialogGroup <> @uid_dialogGroup AND Groupnumber = @Groupnumber)44    BEGIN45      SELECT @Groupnumber = 046    END47    IF @Groupnumber = 048    BEGIN49      SELECT50        @neu = min(isnull(g.Groupnumber, 0) +1)51      FROM dialogGroup g52      WHERE53        NOT EXISTS(54      SELECT TOP 1 155      FROM DialogGroup gt56      WHERE57        isnull(gt.Groupnumber, 0) = isnull(g.Groupnumber, 0) +1)58      EXEC QBM_PSessionContextSet 'GenProcID',59        @GenProcID60      UPDATE dialogGroup61      SET Groupnumber = @neu,62      xdateupdated = GetUTCDate(),63      Xuserupdated = 'DBScheduler'64      WHERE65        uid_dialogGroup = @uid_dialogGroup66      EXEC QBM_PDBQueueInsert_Single 'QBM-K-CommonPrepropGroup',67        @uid_dialogGroup,68      '',69        @GenProcID70      EXEC QBM_PDBQueueInsert_Single 'QBM-K-CommonGroupCollection',71        @uid_dialogGroup,72      '',73        @GenProcID74      EXEC QBM_PDBQueueInsert_Single 'QBM-K-CommonGroupPattern',75        @uid_dialogGroup,76      '',77        @GenProcID78    END79    ELSE80    BEGIN81      EXEC QBM_PDBQueueInsert_Single 'QBM-K-CommonGroupPattern',82        @uid_dialogGroup,83      '',84        @GenProcID85    END86    SELECT87      @VectorLen_new =(isnull(max(isnull(GroupNumber, 0)), 0) / 8) + 188    FROM dialogGroup89    IF isnull(@VectorLen_new,90    0) < 3291    BEGIN92      SELECT @VectorLen_new = 3293    END94    IF @VectorLen_new <> @VectorLen_old95    BEGIN96      EXEC QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate',97      'QBM-K-CommonGroupPattern',98      '',99        @GenProcID100    END101  END TRY102  BEGIN CATCH103    EXEC QBM_PSessionErrorAdd DEFAULT104    RAISERROR('',105    18,106    1)107      WITH NOWAIT108  END CATCH109  ende:110  EXEC QBM_PSessionContextSet 'GenProcID',111    @GenProcID_R112  RETURN113END
Open raw exported source
SQL · Raw16 lines
1      create   procedure QBM_ZGroupNumber ( @SlotNumber int , @uid_dialogGroup varchar(38) , @dummy2 varchar(38) , @GenProcID varchar(38) )  as 2begin  declare @Groupnumber int declare @neu int  declare @VectorLen_old int declare @VectorLen_new int declare @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext3('') BEGIN TRY if not exists (select top 1 1 from DialogGroup where uid_dialogGroup = @uid_dialogGroup ) begin goto ende end  select @VectorLen_old = max4(isnull(datalength(GroupBitPattern), 0)) from dialoggroup if isnull(@VectorLen_old, 0) < 32 begin select @VectorLen_old = 32 end  select top 1 @Groupnumber5 = Groupnumber from dialogGroup where uid_dialogGroup = @uid_dialogGroup if @Groupnumber is null begin select @Groupnumber = 0 end  if @Groupnumber > 06 and exists (select top 1 1 from dialogGroup where uid_dialogGroup <> @uid_dialogGroup and Groupnumber = @Groupnumber ) begin  select @Groupnumber = 0 7 end if @Groupnumber = 0 begin  select @neu = min(isnull(g.Groupnumber, 0) +1) from dialogGroup g where Not exists (select top 1 1 from DialogGroup gt 8where isnull(gt.Groupnumber, 0) = isnull(g.Groupnumber, 0) +1 ) exec QBM_PSessionContextSet 'GenProcID', @GenProcID update dialogGroup set Groupnumber 9= @neu, xdateupdated = GetUTCDate(), Xuserupdated = 'DBScheduler' where uid_dialogGroup = @uid_dialogGroup  exec QBM_PDBQueueInsert_Single 'QBM-K-CommonPrepropGroup'10, @uid_dialogGroup, '', @GenProcID exec QBM_PDBQueueInsert_Single 'QBM-K-CommonGroupCollection', @uid_dialogGroup, '', @GenProcID exec QBM_PDBQueueInsert_Single11 'QBM-K-CommonGroupPattern', @uid_dialogGroup, '', @GenProcID   end else begin  exec QBM_PDBQueueInsert_Single 'QBM-K-CommonGroupPattern', @uid_dialogGroup12, '', @GenProcID end select @VectorLen_new = (isnull(max(isnull(GroupNumber, 0)), 0) / 8)+ 1 from dialogGroup if isnull(@VectorLen_new, 0) < 32 begin select13 @VectorLen_new = 32 end if @VectorLen_new <> @VectorLen_old  begin  exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QBM-K-CommonGroupPattern'14, '', @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  ende: exec QBM_PSessionContextSet15 'GenProcID', @GenProcID_R return end 16