16.20 - Failure Parcels - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

A Failure parcel indicates that the active transaction at the time of the error has been rolled back. In Teradata transaction mode, this includes any requests within the scope of the transaction that had been completed successfully prior to the error. If a failure occurs during the processing of a multi-statement request, all statements within the request are rolled back as well as the transaction.

In ANSI transaction mode, a Failure response parcel rolls back only the statement causing the error unless that error threatens the integrity of Teradata Database, in which case the entire transaction is rolled back. Statements which have not been executed will be discarded.