How to Abort Requests Using the ABORT Command | Basic Teradata Query - 17.00 - Aborting Requests with the ABORT Command - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

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

When issuing the ABORT command, the database:

  1. Stops processing the request.
  2. Discards all of the responses that it 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.