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