StatementError - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
lvt1544831946862.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

Returns information about a problem with a statement in a multi-statement request when the DBCAREA Multi-statement-errors option setting was 'Y'.

Parcel Data

The following information applies to the StatementError parcel.

Flavor Mnemonic TRDSPBEF
Field Length Value
192 TRDSPFSE PBEFSNUM 2-byte unsigned integer The number of the Teradata SQL statement in the Teradata SQL request in which the problem occurred.
PBEFINF 2-byte unsigned integer Any value which is associated with the error code, described in Teradata Vantage™ - Database Messages, B035-1096 for the message number that is the same as the error code.
PBEFCOD 2-byte unsigned integer Database error code, described in Teradata Vantage™ - Database Messages, B035-1096 for the message number that is the same as the error code.
PBEFMTL 2-byte unsigned integer The number of bytes in the message in the PBEFMTX field; zero if no message text is available.
PBEFMTX Characters in the session character set when the request was initiated. Any message text.