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

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-04-02
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
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.