Example: Completing Outstanding Asynchronous SQL Statements - 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

The following example waits on any outstanding asynchronous SQL request to complete and returns control to the program when any one completes, returning the value for the completed asynchronous statement identifier to :requid_var and the value for the ID of the session in which the request ran to completion to :sessid_var.

WAIT COMPLETION INTO :reqid_var, :sessid_var