If the Teradata SQL statement was submitted in Field Mode (Response Mode = F), the response sequence for a successful statement will be as follows if the SQL statement is:
Ok parcel (flavor 17)
if an insert, update or delete statement,
the activity code will reflect the number
of rows affected
all other non-data returning statements
will have an activity code of 0.
EndStatement parcel (flavor 11)
EndRequest parcel (flavor 12)
Ok parcel (flavor 17)
activity count will reflect the number of
rows returned
TitleStart parcel (flavor 20)
Field parcel (flavor 18)
one field parcel for each column returned
TitleEnd parcel (flavor 21)
FormatStart parcel (flavor 22)
Field parcels (flavor 18)
one field parcel for each column returned
FormatEnd parcel (flavor 23)
SizeStart parcel (flavor 24)
Size parcel (flavor 26)
one size parcel for each column returned
SizeEnd parcel (flavor 25)
The following parcel sequence repeats activity count times
RecStart parcel (flavor 27)
Field parcels (flavor 18)
one field parcel for each column
returned
RecEnd parcel (flavor 28)
EndStatement parcel (flavor 11)
EndRequest parcel (flavor12)
Ok parcel (flavor 17)
activity count will reflect the number of
rows returned
TitleStart parcel (flavor 20)
Field parcel (flavor 18)
one field parcel for each column returned
TitleEnd parcel (flavor 21)
FormatStart parcel (flavor 22)
Field parcels (flavor 18)
one field parcel for each column returned
FormatEnd parcel (flavor 23)
SizeStart parcel (flavor 24)
Size parcels (flavor 26)
one size parcel for each column returned
SizeEnd parcel (flavor 25)
The following parcel sequence repeats for each WITH clause
With parcel (flavor 33)
PosStart parcel (flavor 46)
Position parcel (flavor 34)
one position parcel for each column
in WITH
PosEnd parcel (flavor 47)
TitleStart parcel (flavor 20)
Field parcels (flavor 18)
one field parcel for each column in
WITH
TitleEnd parcel (flavor 21)
FormatStart parcel (flavor 22)
Field parcels (flavor 18)
one field parcel for each column
returned
FormatEnd parcel (flavor 23)
SizeStart parcel (flavor 24)
Size parcels (flavor 26)
one size parcel for each column
returned
SizeEnd parcel (flavor 25)
EndWith parcel (flavor 35)
The following parcel sequence repeats activity count times
RecStart parcel (flavor 27)
Field parcels (flavor 18)
one field parcel for each column
returned
RecEnd parcel (flavor 28)
With parcel (flavor 33)
RecStart parcel (flavor 27)
Field parcels (flavor 18)
one field parcel for each column in
WITH
RecEmd parcel (flavor 35)
EndWith parcel (flavor 35)
EndStatement parcel (flavor 11)
EndRequest parcel (flavor 12)
Ok parcel (flavor 17)
RecStart parcel (flavor 27)
Field parcel (flavor 18)
RecEnd parcel (flavor 28)
EndStatement parcel (flavor 11)
EndRequest parcel (flavor 12)