Aborting Requests with the ABORT Command - Basic Teradata Query - 16.20

Basic Teradata Query Reference

prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

Use the ABORT command after the Single-Break function to stop a request to the Teradata Database and restore any changes that were caused by the request.

When issuing the ABORT command, the Teradata Database:

  1. Stops processing the request.
  2. Discards all of the responses that it has prepared for the request.
  3. Backs out all changes that the request made to the database.
  4. Aborts the transaction in which the request was embedded.
  5. Returns a failure message, indicating that the request was aborted.