Back to OIM Explorer

dbo.QER_ZDynGroupSingleHardware

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> QER-K-DynamicGroupSingleBasic / QER_ZDynGroupSingleBasic at line 5; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 909 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 -> QER-K-DynamicGroupSingleBasic / QER_ZDynGroupSingleBasic at line 5
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task QER_ZDynGroupSingleBasic at line 5 Bulk DBQueue insert -> QER-K-DynamicGroupSingleBasic / QER_ZDynGroupSingleBasic at line 5
  • references source dbo.QBM_FGIJobCreatedExists source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task QER-K-DynamicGroupSingleBasic -> QER_ZDynGroupSingleBasic QBM_PDBQueueInsert_Bulk 'QER-K-DynamicGroupSingleBasic' , @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL40 lines
1CREATE PROCEDURE QER_ZDynGroupSingleHardware(2  @SlotNumber int3)4AS5BEGIN6  BEGIN TRY7    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw8    INSERT INTO @DBQueueElements_01(Object,9    SubObject,10    GenProcID)11    SELECT12      cu.UID_Parameter,13      dg.uid_dynamicGroup,14      cu.GenProcID15    FROM QBMDBQueueCurrent cu16      WITH(readpast) CROSS17    JOIN DynamicGroup dg18    JOIN DialogTable t19      WITH(readpast)20      ON dg.UID_DialogTableObjectClass = t.UID_DialogTable21    WHERE22      t.TableName = 'Hardware' AND cu.SlotNumber = @SlotNumber AND dbo.QBM_FGIJobCreatedExists(dg.XObjectKey) = 0 AND NOT EXISTS(23    SELECT TOP 1 124    FROM DialogDBQueue q25      WITH(nolock)26    WHERE27      q.UID_Task = 'QER-K-DynamicGroupTest' AND q.Object = dg.UID_DynamicGroup AND q.Generation >= 0)28    EXEC QBM_PDBQueueInsert_Bulk 'QER-K-DynamicGroupSingleBasic',29      @DBQueueElements_0130  END TRY31  BEGIN CATCH32    EXEC QBM_PSessionErrorAdd DEFAULT33    RAISERROR('',34    18,35    1)36      WITH NOWAIT37  END CATCH38  ende:39  RETURN40END
Open raw exported source
SQL ยท Raw7 lines
1    create   procedure QER_ZDynGroupSingleHardware (@SlotNumber int)  as begin BEGIN TRY declare @DBQueueElements_01 QBM_YDBQueueRaw insert into2 @DBQueueElements_01(Object, SubObject, GenProcID) select cu.UID_Parameter, dg.uid_dynamicGroup , cu.GenProcID from QBMDBQueueCurrent cu with (readpast3) cross join DynamicGroup dg join DialogTable t with (readpast) on dg.UID_DialogTableObjectClass = t.UID_DialogTable where t.TableName = 'Hardware' and4 cu.SlotNumber = @SlotNumber   and dbo.QBM_FGIJobCreatedExists(dg.XObjectKey) = 0   and not exists (Select top 1 1 from DialogDBQueue q with (nolock) where5 q.UID_Task = 'QER-K-DynamicGroupTest' and q.Object = dg.UID_DynamicGroup  and q.Generation >= 0 ) exec QBM_PDBQueueInsert_Bulk 'QER-K-DynamicGroupSingleBasic'6, @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 7