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

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.