17.10 - Failure - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

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
  • StatementNo:
  • Info:
  • Code:
  • Length:
  • Msg:
  • 2-byte unsigned integer
  • 2-byte unsigned integer
  • 2-byte unsigned integer
  • 2-byte unsigned integer
  • 1 to 255 bytes

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.