Aborting Requests with the ABORT Command - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
wmy1488824663431.ditamap
dita:ditavalPath
Audience_PDF_include.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 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.