TDWMReleaseDelayedRequest Examples - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Using TDWMReleaseDelayedRequest to Release a Delayed Request

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

Using TDWMReleaseDelayedRequest to Release Multiple Delayed Requests

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