16.20 - Statement-status - Teradata Tools and Utilities

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

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

Statement-status specifies whether the Teradata Database may return Statement Status parcels instead of Success or OK parcels. Even if Statement-status is specified as 'D' or 'E', the Teradata Database may, at its discretion, return Success and OK parcels so the application should be prepared to handle either parcel.

In this language... The variable name for Statement-status is...
COBOL DBCNISS
PL/I DBCNISS
C, C++ dbcniSS
IBM Assembler DBCNISS
This routine... Does this for Statement-status. . .
DBCHINI writes
DBCHCL Reads (CON, IRQ, IWPF)
Statement-status is used by... To...
applications write
If StatementStatus... Statement-status to
indicates that Success or OK parcels are returned 'O'
indicates that StatementStatus parcels may be returned 'E'
indicates that StatementStatus parcels may be returned along with any optional description extensions 'D'
Unless a new application must support old versions of the Teradata Database, which would reject its use, Statement-status should always be set to 'E'. The CLIv2 Query routine QEPIESS (or QEPIASL) can be used to ascertain if the Database supports this enhancement.

Use mnemonics for the codes. Mnemonics are provided in the language definition file for the DBCAREA.