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
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-12
dita:mapPath
uny1527114222311.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

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