17.10 - Aborting a Request - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)
If a request is active or a transaction has an active request, the application program can attempt to abort the request and transaction, if any. Such an abort is called an asynchronous abort.
  • If the abort reaches the database before the Start Response message is returned, the Teradata SQL response in preparation is discarded, the active Teradata SQL request is closed out, and any effect of the active Teradata SQL request and any other Teradata SQL request in the transaction (if any) are backed out of the database.
  • If the abort reaches the database after the Start Response message is returned, the abort does not take effect.