Multi-Statement-Errors - 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

Usage Notes

Multi-statement-errors is a one byte ASCII field that indicates whether each statement in a multi-statement request may reflect an error for certain limited conditions using the StatementError parcel.

Language Variable Name
COBOL: MULTISTATEMENTERRORS
C: multiStatementErrors
Routine Action Taken
DBCHINI: writes
DBCHCL: reads (RSUP; IRQ)
Used by Action Taken
applications write
One of the following values may be set before initiating a request:
  • 'N' – the value of 'N' indicates that a problem with any statement in a multi-statement request ends processing of that request.
  • 'Y' – the value of 'Y' indicates that certain problems with a statement in a multi-statement request allows other statements to be processed.

The default setting is 'N'.

With Multi-statement-errors=N, a problem with any statement in a multi-statement request results in a single Failure parcel indicating which statement had the problem; none of the statements were executed. With Multi-statement-errors=Y, processing is the same unless all errors are of certain limited types, in which case the response to statements having those problems is a StatementError parcel; the response to all other statements are the usual Success, OK, or ResultSummary parcels.