MultipartIndicator Mode requests may return the following parcels:
| Name | Flavor |
|---|---|
| Failure | 9 |
| Error | 49 |
| StatementError | 192 |
| Success | 8 |
| StatementStatus | 205 |
| DataInfoX | 146 |
| MultipartRecord | 144 |
| StatementInformation | 169 |
| StatementInformationEnd | 170 |
| EndMultipartRecord | 145 |
| With | 33 |
| EndWith | 35 |
| PosStart | 46 |
| Position | 34 |
| PosEnd | 47 |
| EndStatement | 11 |
| EndRequest | 12 |
The following examples assume successful completion of the request when using Original Statement-status. If using Enhanced Statement-status, OK parcels may be replaced by StatementStatus parcels. See Parcels for Basic Applications or Parcels for Advanced Applications for detailed descriptions of parcels.
The following examples assume that the Return-statement-info 'Y' option was not specified; if specified, DataInfoX parcels will be replaced by StatementInformation and StatementInformationEnd parcels.
| UPDATE TABLE1 SET FIELD1 = 999999 | ||
|---|---|---|
| Parcel | Flavor | Body |
| Success | 8 | (1, 23, 0, 0, 3, 0) |
| EndStatement | 11 | (1) |
| EndRequest | 12 | |
| UPDATE TABLE1 SET FIELD1 = 999999 | ||
|---|---|---|
| Parcel | Flavor | Body |
| Success | 8 | (1, 23, 0, 1, 1, 0) |
| DataInfoX | 146 | (1, 496, 4) |
| MultipartRecord(s) for row 1 | 144 | (ind, data) |
| EndMultipartRecord | 145 | (ind, data) |
| MultipartRecord(s) for row 23 | 144 | (ind, data) |
| EndMultipartRecord | 145 | (ind, data) |
| EndStatement | 11 | (1) |
| EndRequest | 12 | |
| SELECT FIELD1 FROM TABLE1 WITH SUM (FIELD1); | ||
|---|---|---|
| Parcel | Flavor | Body |
| Success | 8 | (1, 24, 0, 1, 1, 0) |
| DataInfoX | 146 | (1, 496, 4) |
| With | 33 | (1) |
| PosStart | 46 | |
| Position | 34 | (1) |
| PosEnd | 47 | |
| DataInfoX | 146 | (1, 496, 4) |
| EndWith | 35 | (1) |
| MultipartRecord(s) for row 1 | 144 | (ind, data) |
| EndMultipartRecord | 145 | |
| MultipartRecord (s)for row 23 | 144 | (ind, data) |
| EndMultipartRecord | 145 | |
| With | 33 | (1) |
| MultipartRecord(s) | 144 | (ind,data) |
| EndMultipartRecord | 145 | |
| EndWith | 35 | (1) |
| EndStatement | 11 | (1) |
| EndRequest | 12 | |
| SELECT FIELD1 FROM TABLE1; SELECT FIELD2 FROM TABLE2; | ||
|---|---|---|
| Parcel | Flavor | Body |
| Success | 8 | (1, 23, 0, 1, 1, 0) |
| DataInfoX | 146 | (1, 496, 4) |
| MultipartRecord(s) for row 1 | 144 | (ind, data) |
| EndMultipartRecord | 145 | |
| MultipartRecord(s) for row 23 | 144 | (ind, data) |
| EndMultipartRecord | 145 | |
| EndStatement | 11 | (1) |
| Success | 8 | (2, 10, 0, 1, 1, 0) |
| DataInfoX | 71 | (2, 496, 4) |
| MultipartRecord(s) for row 1 | 144 | (ind, data) |
| EndMultipartRecord | 145 | |
| MultipartRecord(s) for row 10 | 144 | (ind, data) |
| EndMultipartRecord | 145 | |
| EndStatement | 11 | (2) |
| EndRequest | 12 | |
| ECHO ̀SELECT FIELD1 FROM TABLE1́; | ||
|---|---|---|
| Parcel | Flavor | Body |
| Success | 8 | (1, 0, 0, 1, 33, 0) |
| MultipartRecord(s) | 144 | (ind, data) |
| EndMultipartRecord | 145 | |
| EndStatement | 11 | (1) |
| EndRequest | 12 | |