Back to OIM Explorer

dbo.QBM_ZViewBuildAll

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> QBM-K-CommonRebuildViewV / QBM_ZViewBuildV at line 5; Bulk DBQueue insert -> QBM-K-CommonRebuildViewP / QBM_ZViewBuildP at line 5; Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 5; Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 5

Source: sandbox-db sys.sql_modules

Source size: 2.122 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

  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewV / QBM_ZViewBuildV at line 5
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewP / QBM_ZViewBuildP at line 5
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 5
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 5
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewP / QBM_ZViewBuildP at line 8
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 8
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 8
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 10
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 10
  • Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 13
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task QBM_ZViewBuildV at line 5 Bulk DBQueue insert -> QBM-K-CommonRebuildViewV / QBM_ZViewBuildV at line 5
  • queues DBQueue task QBM_ZViewBuildP at line 5 Bulk DBQueue insert -> QBM-K-CommonRebuildViewP / QBM_ZViewBuildP at line 5
  • queues DBQueue task QBM_ZViewBuildU at line 5 Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 5
  • queues DBQueue task QBM_ZViewBuildR at line 5 Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 5
  • queues DBQueue task QBM_ZViewBuildP at line 8 Bulk DBQueue insert -> QBM-K-CommonRebuildViewP / QBM_ZViewBuildP at line 8
  • queues DBQueue task QBM_ZViewBuildU at line 8 Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 8
  • queues DBQueue task QBM_ZViewBuildR at line 8 Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 8
  • queues DBQueue task QBM_ZViewBuildU at line 10 Bulk DBQueue insert -> QBM-K-CommonRebuildViewU / QBM_ZViewBuildU at line 10
  • queues DBQueue task QBM_ZViewBuildR at line 10 Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 10
  • queues DBQueue task QBM_ZViewBuildR at line 13 Bulk DBQueue insert -> QBM-K-CommonRebuildViewR / QBM_ZViewBuildR at line 13
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task QBM-K-CommonRebuildViewV -> QBM_ZViewBuildV QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewV' , @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select p.uid_paramet…
  • queues DBQueue task QBM-K-CommonRebuildViewP -> QBM_ZViewBuildP QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewP', @DBQueueElements_02 declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select p.uid_paramete…
  • queues DBQueue task QBM-K-CommonRebuildViewU -> QBM_ZViewBuildU QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewU' , @DBQueueElements_03 declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select p.uid_paramet…
  • queues DBQueue task QBM-K-CommonRebuildViewR -> QBM_ZViewBuildR QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewR', @DBQueueElements_04 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL115 lines
1CREATE PROCEDURE QBM_ZViewBuildAll(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent7  BEGIN TRY8    INSERT INTO @DBQueueCurrent(UID_DialogDBQueue,9    UID_Parameter,10    UID_SubParameter,11    GenProcID)12    SELECT13      UID_DialogDBQueue,14      UID_Parameter,15      UID_SubParameter,16      GenProcID17    FROM QBMDBQueueCurrent cu18      WITH(readpast)19    WHERE20      cu.SlotNumber = @SlotNumber21    IF @@rowcount = 022    BEGIN23      GOTO EndLabel24    END25    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw26    INSERT INTO @DBQueueElements_01(object,27    subobject,28    genprocid)29    SELECT30      x.uid,31      NULL,32      x.GenProcID33    FROM(34    SELECT35      p.uid_parameter AS uid,36      p.GenprocID37    FROM @DBQueueCurrent p38    JOIN DialogTable t39      WITH(readpast)40      ON p.UID_Parameter = t.UID_DialogTable41    WHERE42      t.TableType = 'V') AS x43    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewV',44      @DBQueueElements_0145    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw46    INSERT INTO @DBQueueElements_02(object,47    subobject,48    genprocid)49    SELECT50      x.uid,51      NULL,52      x.GenProcID53    FROM(54    SELECT55      p.uid_parameter AS uid,56      p.GenprocID57    FROM @DBQueueCurrent p58    JOIN DialogTable t59      WITH(readpast)60      ON p.UID_Parameter = t.UID_DialogTable61    WHERE62      t.TableType = 'P') AS x63    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewP',64      @DBQueueElements_0265    DECLARE @DBQueueElements_03 QBM_YDBQueueRaw66    INSERT INTO @DBQueueElements_03(object,67    subobject,68    genprocid)69    SELECT70      x.uid,71      NULL,72      x.GenProcID73    FROM(74    SELECT75      p.uid_parameter AS uid,76      p.GenprocID77    FROM @DBQueueCurrent p78    JOIN DialogTable t79      WITH(readpast)80      ON p.UID_Parameter = t.UID_DialogTable81    WHERE82      t.TableType = 'U') AS x83    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewU',84      @DBQueueElements_0385    DECLARE @DBQueueElements_04 QBM_YDBQueueRaw86    INSERT INTO @DBQueueElements_04(object,87    subobject,88    genprocid)89    SELECT90      x.uid,91      NULL,92      x.GenProcID93    FROM(94    SELECT95      p.uid_parameter AS uid,96      p.GenprocID97    FROM @DBQueueCurrent p98    JOIN DialogTable t99      WITH(readpast)100      ON p.UID_Parameter = t.UID_DialogTable101    WHERE102      t.TableType = 'R') AS x103    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewR',104      @DBQueueElements_04105  END TRY106  BEGIN CATCH107    EXEC QBM_PSessionErrorAdd DEFAULT108    RAISERROR('',109    18,110    1)111      WITH NOWAIT112  END CATCH113  endLabel:114  RETURN115END
Open raw exported source
SQL · Raw15 lines
1   create   procedure QBM_ZViewBuildAll (@SlotNumber int) AS begin declare @DBQueueCurrent QBM_YDBQueueCurrent BEGIN TRY insert into @DBQueueCurrent2(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent3 cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end declare @DBQueueElements_01 QBM_YDBQueueRaw insert into4 @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select p.uid_parameter as uid, p.GenprocID from @DBQueueCurrent5 p join DialogTable t with (readpast) on p.UID_Parameter = t.UID_DialogTable where t.TableType = 'V' ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewV'6, @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, x.GenProcID7 from ( select p.uid_parameter as uid, p.GenprocID from @DBQueueCurrent p join DialogTable t with (readpast) on p.UID_Parameter = t.UID_DialogTable where8 t.TableType = 'P' ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewP', @DBQueueElements_02 declare @DBQueueElements_03 QBM_YDBQueueRaw insert9 into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select p.uid_parameter as uid, p.GenprocID from @DBQueueCurrent10 p join DialogTable t with (readpast) on p.UID_Parameter = t.UID_DialogTable where t.TableType = 'U' ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewU'11, @DBQueueElements_03 declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, subobject, genprocid) select x.uid, null, x.GenProcID12 from ( select p.uid_parameter as uid, p.GenprocID from @DBQueueCurrent p join DialogTable t with (readpast) on p.UID_Parameter = t.UID_DialogTable where13 t.TableType = 'R' ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonRebuildViewR', @DBQueueElements_04 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default14 RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 15