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