Back to OIM Explorer

dbo.ATT_ZAttestationCheck

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> ATT-K-AttestationCheckValid / ATT_ZAttestationCheckValid at line 4; Bulk DBQueue insert -> ATT-K-AttestationCheckValid / ATT_ZAttestationCheckValid at line 4; Bulk DBQueue insert -> ATT-K-AttestationCheckValid / ATT_ZAttestationCheckValid at line 8; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 1.357 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 -> ATT-K-AttestationCheckValid / ATT_ZAttestationCheckValid at line 4
  • Bulk DBQueue insert -> ATT-K-AttestationCheckValid / ATT_ZAttestationCheckValid at line 4
  • Bulk DBQueue insert -> ATT-K-AttestationCheckValid / ATT_ZAttestationCheckValid at line 8
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task ATT_ZAttestationCheckValid at line 4 Bulk DBQueue insert -> ATT-K-AttestationCheckValid / ATT_ZAttestationCheckValid at line 4
  • queues DBQueue task ATT_ZAttestationCheckValid at line 8 Bulk DBQueue insert -> ATT-K-AttestationCheckValid / ATT_ZAttestationCheckValid at line 8
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task ATT-K-AttestationCheckValid -> ATT_ZAttestationCheckValid QBM_PDBQueueInsert_Bulk 'ATT-K-AttestationCheckValid' , @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select distinct pwo…

References

Referenced By

Complete Source

SQL56 lines
1CREATE PROCEDURE ATT_ZAttestationCheck(2  @Slotnumber int,3  @Dummy1 varchar(38),4  @Dummy2 varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  BEGIN TRY10    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw11    INSERT INTO @DBQueueElements_01(object,12    subobject,13    genprocid)14    SELECT15      x.uid,16      NULL,17      @GenProcID18    FROM(19    SELECT20      DISTINCT pwo.UID_AttestationCase AS uid21    FROM AttestationCase pwo22    JOIN AttestationHelper h23      ON pwo.uid_AttestationCase = h.uid_AttestationCase24    WHERE25      (h.NextReminder < getutcdate() OR h.NextAutomaticDecision < getutcdate()) AND pwo.IsUnderConstruction = 0) AS x26    EXEC QBM_PDBQueueInsert_Bulk 'ATT-K-AttestationCheckValid',27      @DBQueueElements_0128    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw29    INSERT INTO @DBQueueElements_02(object,30    subobject,31    genprocid)32    SELECT33      x.uid,34      NULL,35      @GenProcID36    FROM(37    SELECT38      DISTINCT pwo.UID_AttestationCase AS uid39    FROM AttestationCase pwo40    JOIN AttestationHelper h41      ON pwo.uid_AttestationCase = h.uid_AttestationCase42    JOIN QERWorkingMethod wm43      ON pwo.UID_QERWorkingMethod= wm.UID_QERWorkingMethod44    WHERE45      dateadd(dd, wm.DaysToAbort, pwo.Xdateinserted) < getutcdate() AND isnull(wm.DaysToAbort, 0) > 0 AND pwo.IsUnderConstruction = 0) AS x46    EXEC QBM_PDBQueueInsert_Bulk 'ATT-K-AttestationCheckValid',47      @DBQueueElements_0248  END TRY49  BEGIN CATCH50    EXEC QBM_PSessionErrorAdd DEFAULT51    RAISERROR('',52    18,53    1)54      WITH NOWAIT55  END CATCH56END
Open raw exported source
SQL · Raw10 lines
1   create   procedure ATT_ZAttestationCheck ( @Slotnumber int , @Dummy1 varchar(38) , @Dummy2 varchar(38) , @GenProcID varchar(38) ) AS begin BEGIN2 TRY  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select3 distinct pwo.UID_AttestationCase as uid from AttestationCase pwo join AttestationHelper h on pwo.uid_AttestationCase = h.uid_AttestationCase where (h.NextReminder4 < getutcdate() or h.NextAutomaticDecision < getutcdate() ) and pwo.IsUnderConstruction = 0 ) as x exec QBM_PDBQueueInsert_Bulk 'ATT-K-AttestationCheckValid'5, @DBQueueElements_01  declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID6 from (select distinct pwo.UID_AttestationCase as uid from AttestationCase pwo join AttestationHelper h on pwo.uid_AttestationCase = h.uid_AttestationCase7 join QERWorkingMethod wm on pwo.UID_QERWorkingMethod= wm.UID_QERWorkingMethod where dateadd(dd, wm.DaysToAbort, pwo.Xdateinserted) < getutcdate() and 8isnull(wm.DaysToAbort, 0) > 0 and pwo.IsUnderConstruction = 0 ) as x exec QBM_PDBQueueInsert_Bulk 'ATT-K-AttestationCheckValid', @DBQueueElements_02 END9 TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 10