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