Issuing Requests: Record Mode - Call-Level Interface Version 2

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” on page 181.

Table 35: Update Table1 Set Field1=999999; 

Parcel	Flavor	Body
Success	8	(1, 23, 0, 0, 3, 0)
EndStatement	11	(1)
EndRequest	12

Table 36: 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

Table 37: 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

Table 38: 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

Table 39: 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