Examples
The following examples assume successful completion of the request.
Example
UPDATE TABLE1 SET FIELD1 999999
Parcel |
Flavor |
Parcel Body Fields |
Success |
8 |
(1, 23, 0, 0, 3, 0) |
EndStatement |
11 |
(1) |
EndRequest |
|
|
Example
Select field1 from table1
Parcel |
Flavor |
Parcel Body Fields |
Success |
8 |
(1, 23, 0, 0, 3, 0) |
DataInfox |
146 |
(1, 496, 4) |
Multipart record |
144 |
(indicator, data) |
End Multipart Record |
145 |
|
Multipart record |
144 |
(indicator, data) |
End Multipart Record |
145 |
|
End Statement |
11 |
|
End Request |
10 |
|
Example
SELECT FIELD1 FROM TABLE1 WITH SUM (FIELD1);
Parcel |
Flavor |
Parcel Body Fields |
Success |
8 |
(1, 23, 0, 0, 3, 0) |
DataInfox |
146 |
(1, 496, 4) |
With |
33 |
(1) |
PosStart |
46 |
|
Position |
34 |
1 |
PosEnd |
47 |
|
DataInfox |
146 |
(1, 496, 4) |
EndWith |
35 |
(1) |
Multipart record |
144 |
(indicator, data) |
End Multipart Record |
145 |
|
Multipart record |
144 |
(indicator, data) |
End Multipart Record |
145 |
|
with |
33 |
(1) |
Multipart record |
144 |
(indicator, data) |
End Multipart Record |
145 |
|
EndWith |
35 |
(1) |
End Statement |
11 |
(1) |
End Request |
10 |
|
Example
SELECT FIELD1 FROM TABLE1; SELECT FIELD2 FROM TABLE2;
Parcel |
Flavor |
Parcel Body Fields |
Success |
8 |
(1, 23, 0, 0, 3, 0) |
DataInfox |
146 |
(1, 496, 4) |
Multipart record |
144 |
(indicator, data) |
End Multipart Record |
145 |
|
Multipart record |
144 |
(indicator, data) |
End Multipart Record |
145 |
|
End Statement |
11 |
|
Success |
8 |
(1, 23, 0, 0, 3, 0) |
DataInfox |
146 |
(1, 496, 4) |
Multipart record |
144 |
(indicator, data) |
End Multipart Record |
145 |
|
Multipart record |
144 |
(indicator, data) |
End Multipart Record |
145 |
|
End Statement |
11 |
(1) |
End Request |
10 |
|
Example
ECHO “SELECT FIELD1 FROM TABLE1”
Parcel |
Flavor |
Parcel Body Fields |
Success |
8 |
(1, 0, 0, 1, 33, 0) |
Multipart record(s) |
144 |
(ind, data) |
EndMultipartRecord |
145 |
|
End Statement |
11 |
(1) |
End Request |
10 |
|