Issuing Requests—Record Mode
Record Mode requests may return the following parcels:
Name |
Flavor |
Failure |
9 |
Error |
49 |
StatementError |
192 |
Success |
8 |
StatementStatus |
205 |
Record |
10 |
With |
33 |
EndWith |
35 |
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.
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) |
Record (1) . . . Record (23) |
10 . . . 10 |
(data) . . . (data) |
EndStatement |
11 |
(1) |
EndRequest |
12 |
|
SELECT FIELD1 FROM TABLE1 WITH SUM (FIELD1); |
||
Parcel |
Flavor |
Body |
Success |
8 |
(1, 24, 0, 1, 1, 0) |
Record (1) . . . Record (23) |
10 . . . 10 |
(data) . . . (data) |
With |
33 |
(1) |
Record |
10 |
(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) |
Record (1) . . . Record (23) |
10 . . . 10 |
(data) . . . (data) |
EndStatement |
11 |
(1) |
Success |
8 |
(2, 10, 0, 1, 1, 0) |
Record (1) . . . Record (10) |
10 . . . 10 |
(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 |
|