Indicator Mode requests may return the following parcels:
Name |
Flavor |
Failure |
9 |
Error |
49 |
StatementError |
192 |
Success |
8 |
StatementStatus |
205 |
DataInfo |
71 |
StatementInformation |
169 |
StatementInformationEnd |
170 |
Record |
10 |
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 Chapter 15: “Parcels for Basic Applications” or Chapter 16: “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 |
|
SELECT FIELD1 FROM TABLE1; |
|
|
Parcel |
Flavor |
Body |
Success |
8 |
(1, 23, 0, 1, 1, 0) |
DataInfo (continued) |
71 |
(1, 496, 4) |
Record (1) . . . Record (23) |
10 . . . 10 |
(ind, data) . . . (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) |
DataInfo |
71 |
(1, 496, 4) |
With |
33 |
(1) |
PosStart |
46 |
|
Position |
34 |
(1) |
PosEnd |
47 |
|
DataInfo |
71 |
(1, 496, 4) |
EndWith |
35 |
(1) |
Record (1) |
10 |
(ind,data) |
. |
. |
. |
. . |
. . |
. . |
Record (23) |
10 |
(ind,data) |
With |
33 |
(1) |
Record |
10 |
(ind,data) |
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) |
DataInfo |
71 |
(1, 496, 4) |
Record (1) . . . Record (23) |
10 . . . 10 |
(ind.data) . . . (ind,data) |
EndStatement |
11 |
(1) |
Success |
8 |
(2, 10, 0, 1, 1, 0) |
DataInfo |
71 |
(2, 496, 4) |
Record (1) . . . Record (10) |
10 . . . 10 |
(ind,data) . . . (data) |
EndStatement |
11 |
(2) |
EndRequest |
12 |
|
ECHO ‘SELECT FIELD1 FROM TABLE1‘; |
||
Parcel |
Flavor |
Body |
Success |
8 |
(1, 0, 0, 1, 33, 0) |
Record |
10 |
(echoed string) |
EndStatement |
11 |
(1) |
EndRequest |
12 |
|