TDWMAbortDelayedRequest Example - Teradata VantageCloud Lake

This example shows how to stop a delayed request on SessionNo 1011.

SELECT TDWM.TDWMAbortDelayedRequest(HostId, SessionNo, RequestNo, 0)
 FROM TABLE (TDWMGetDelayedQueries('O')) AS t1
  WHERE SessionNo=1011;
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 3 seconds.
TDWMAbortDelayedRequest(HostId,SessionNo,RequestNo,0)
-----------------------------------------------------
                                                    0

The request on SessionNo 1011, if delayed, is stopped as follows:

SELECT DatabaseName FROM dbc.databasesv;
 *** Starting at Tue Apr 26 15:22:42 2005
 *** Failure 3151 TWM Workload violation: Delay Request Change Abort
                Statement# 1, Info =0