Issuing Requests—Field Mode
Field Mode requests may return the following parcels:
Name |
Flavor |
Failure |
9 |
Error |
49 |
StatementError |
192 |
OK |
17 |
ResultSummary |
171 |
Field |
18 |
With |
33 |
EndWith |
35 |
FormatStart |
22 |
FormatEnd |
23 |
NullField |
19 |
PosStart |
46 |
Position |
34 |
PosEnd |
47 |
RecStart |
28 |
RecEnd |
28 |
SizeStart |
24 |
Size |
26 |
SizeEnd |
25 |
TitleStart |
20 |
TitleEnd |
21 |
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 |
OK |
17 |
(1, 0, 23, 3, 0, 0) |
EndStatement |
11 |
(1) |
EndRequest |
12 |
|
SELECT FIELD1 FROM TABLE1; |
|
|
Parcel |
Flavor |
Body |
OK |
17 |
(1, 1, 23, 1, 0, 0) |
TitleStart |
20 |
|
Field |
18 |
(title) |
TitleEnd |
21 |
|
FormatStart |
22 |
|
Field |
18 |
(format) |
FormatEnd |
23 |
|
SizeStart |
24 |
|
Size |
26 |
(size) |
SizeEnd |
25 |
|
RecStart (1) |
27 |
|
Field |
18 |
(data) |
RecEnd (1) |
28 |
|
. . . |
. . . |
|
RecStart (23) |
27 |
|
Field |
18 |
(data) |
RecEnd (23) |
28 |
|
EndStatement |
11 |
(1) |
EndRequest |
12 |
|
SELECT FIELD1 FROM TABLE1 WITH SUM (FIELD1) |
||
Parcel |
Flavor |
Body |
OK |
17 |
(1, 1, 24, 1, 0, 0) |
TitleStart |
20 |
|
Field |
18 |
(title) |
TitleEnd |
21 |
|
FormatStart |
22 |
|
Field |
18 |
(format) |
FormatEnd |
23 |
|
SizeStart |
24 |
|
Size |
26 |
(size) |
SizeEnd |
25 |
|
With |
33 |
(1) |
PosStart |
46 |
|
Position |
34 |
(1) |
PosEnd |
47 |
|
TitleStart |
20 |
|
Field |
18 |
(title) |
TitleEnd |
21 |
|
FormatStart |
22 |
|
Field |
18 |
(format) |
FormatEnd |
23 |
|
SizeStart |
24 |
|
Size |
26 |
(size) |
SizeEnd |
25 |
|
EndWith |
35 |
(1) |
RecStart (1) |
27 |
|
Field |
18 |
(data) |
RecEnd (1) |
28 |
|
. . . |
. . . |
|
RecStart (23) |
27 |
|
Field |
18 |
(data) |
RecEnd (23) |
28 |
|
With |
33 |
(1) |
Field |
18 |
(data) |
EndWith |
35 |
(1) |
EndStatement |
11 |
(1) |
EndRequest |
12 |
|
SELECT FIELD1 FROM TABLE1; SELECT FIELD2 FROM TABLE2; |
||
Parcel |
Flavor |
Body |
OK |
17 |
(1, 1, 23, 1, 0, 0) |
TitleStart |
20 |
|
Field |
18 |
(title) |
TitleEnd |
21 |
|
FormatStart |
22 |
|
Field |
18 |
(format) |
FormatEnd |
23 |
|
SizeStart |
24 |
|
Size |
26 |
(size) |
SizeEnd |
25 |
|
RecStart (1) |
27 |
|
Field |
18 |
(data) |
RecEnd (1) |
28 |
|
. . |
. . |
|
RecStart (23) |
27 |
|
Field |
18 |
(data) |
RecEnd |
28 |
|
EndStatement |
11 |
(1) |
OK |
17 |
(2, 1, 10, 1, 0, 0) |
TitleStart |
20 |
|
Field |
18 |
(title) |
TitleEnd |
21 |
|
FormatStart |
22 |
|
Field |
18 |
(format) |
FormatEnd |
23 |
|
SizeStart |
24 |
|
Size |
26 |
(size) |
SizeEnd |
25 |
|
RecStart (1) |
27 |
|
Field |
18 |
(data) |
RecEnd (1) |
28 |
|
. . . |
. . . |
|
RecStart (10) |
27 |
|
Field |
18 |
(data) |
RecEnd (10) |
28 |
|
EndStatement |
11 |
(2) |
EndRequest |
12 |
|
ECHO ‘SELECT FIELD1 FROM TABLE1‘; |
||
Parcel |
Flavor |
Body |
OK |
17 |
(1, 1, 0, 33, 0, 0) |
RecStart |
27 |
|
Field |
18 |
(data) |
RecEnd |
28 |
|
EndStatement |
11 |
(1) |
EndRequest |
12 |
|