Failure - Call-Level Interface Version 2

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
Product Category
Teradata Tools and Utilities

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.