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.