Record Mode requests may return the following parcels:
- EndRequest (flavor 12)
- EndStatement (flavor 11)
- EndWith (flavor 35)
- Error (flavor 49)
- Failure (flavor 9)
- Record (flavor 10)
- Success (flavor 8)
- With (flavor 33)
The following tables are examples that assume successful completion of the request. For a description of the contents of a parcel body, see Initiate-request Extensions.
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)
|
|
|
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)
|
|
|
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)
|
|
|
EndStatement |
11 |
(1) |
Success |
8 |
(2, 10, 0, 1, 1, 0) |
- Record (1)
- .
- .
- .
- Record (10)
|
|
|
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 |
|