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
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

Failure

Purpose

Indicates that the response to a request was not successfully processed by the Teradata server.

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 data base.

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 Teradata server.

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:

  • 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 the Messages (B035‑1096) manual.
  • 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.