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