Purpose
Indicates that the response to a request was not successfully processed by the database.
Usage Notes
In contrast to the Error parcel, the Failure parcel indicates that the Teradata SQL response has been discarded and the Teradata SQL request and transaction in which it was embedded, if any, have been aborted and backed out of the database.
When ANSI transaction semantics are in effect, a Failure response parcel rolls back only the request causing the error unless that error threatens the integrity of the database, in which case the entire transaction is rolled back.
This parcel is generated by the database.
Parcel Data
The following table lists field information for Error.
| Flavor | Parcel Body Length | Parcel Body Fields | |
|---|---|---|---|
| 9 | 8 to 263 |
|
|
Field Notes
Failure Parcel fields are defined as follows:
- StatementNo is the number of the Teradata SQL statement in the Teradata SQL request that failed.
- Info is an integer value whose use depends upon the failure code returned. For its contents, look up the error code in Teradata Vantage™ - Database Messages, B035-1096.
- Code is the error code specifying the type of error that occurred.
- Length is the total number of bytes in the textual representation of the Failure Code. If Length = 0, no textual representation of the error is present.
- Msg is the failure message in character format.