The following examples assume successful completion of the request.
Example 1
UPDATE TABLE1 SET FIELD1 999999
Parcel | Flavor | Parcel Body Fields |
---|---|---|
Success | 8 | (1, 23, 0, 0, 3, 0) |
EndStatement | 11 | (1) |
EndRequest |
Example 2
Select field1 from table1
Parcel | Flavor | Parcel Body Fields |
---|---|---|
Success | 8 | (1, 23, 0, 0, 3, 0) |
DataInfox | 146 | (1, 496, 4) |
Multipart record for row 1 | 144 | (indicator, data) |
End Multipart Record | 145 | |
Multipart record for row 2 | 144 | (indicator, data) |
End Multipart Record | 145 | |
End Statement | 11 | |
End Request | 10 |
Example 3
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 for row 1 | 144 | (indicator, data) |
End Multipart Record | 145 | |
Multipart record for row 2 | 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 4
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 for row 1 | 144 | (indicator, data) |
End Multipart Record | 145 | |
Multipart record for row 2 | 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 for row 1 | 144 | (indicator, data) |
End Multipart Record | 145 | |
Multipart record for row 2 | 144 | (indicator, data) |
End Multipart Record | 145 | |
End Statement | 11 | (1) |
End Request | 10 |
Example 5
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 |