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 Teradata SQL statement is... |
Then the response parcels are as follows... |
|
non-data returning |
OK parcel (flavor 17) or StatementStatus (flavor 205) , the activity count will reflect the number of rows affected if an insert, update or delete statement; the activity count is zero for all other non-data returning statements. |
|
|
EndStatement parcel (flavor 11) |
|
|
EndRequest parcel (flavor 12) |
|
data returning, or a Select statement with no WITH clause
|
OK parcel (flavor 17) or StatementStatus (flavor 205) , the activity count will reflect the number of rows returned. |
|
TitleStart parcel (flavor 20) |
||
The following parcel is repeated once for each column returned: |
||
|
Field parcel (flavor 18) |
|
|
TitleEnd parcel (flavor 21) |
|
|
FormatStart parcel (flavor 22) |
|
|
The following parcel is repeated once for each column returned: |
|
|
Field parcel (flavor 18) |
|
|
FormatEnd parcel (flavor 23) |
|
|
SizeStart parcel (flavor 24) |
|
|
The following parcel is repeated once for each column returned: |
|
|
Size parcel (flavor 26) |
|
|
SizeEnd parcel (flavor 25) |
|
|
The following parcels are repeated activity-count number of times: |
|
|
RecStart parcel (flavor 27) |
|
|
The following parcel is repeated once for each column returned: |
|
|
Field parcel (flavor 18) |
|
|
RecEnd parcel (flavor 28) |
|
|
EndStatement parcel (flavor 11) |
|
|
EndRequest parcel (flavor 12) |
|
a Select statement having one or more WITH clauses |
OK parcel (flavor 17) or StatementStatus (flavor 205) , the activity count will reflect the number of rows returned. |
|
TitleStart parcel (flavor 20) |
||
|
The following parcel is repeated once for each column returned: |
|
|
Field parcel (flavor 18) |
|
|
TitleEnd parcel (flavor 21) |
|
|
FormatStart parcel (flavor 22) |
|
|
The following parcel is repeated once for each column returned: |
|
|
Field parcel (flavor 18) |
|
|
FormatEnd parcel (flavor 23) |
|
|
SizeStart parcel (flavor 24) |
|
|
The following parcel is repeated once for each column returned: |
|
|
Size parcel (flavor 26) |
|
|
SizeEnd parcel (flavor 25) |
|
|
The following parcels repeat for each WITH clause: |
|
|
With parcel (flavor 33) |
|
|
PosStart parcel (flavor 46) |
|
|
The following parcel is repeated once for each column in WITH clause: |
|
|
Position parcel (flavor 34) |
|
|
PosEnd parcel (flavor 47) |
|
|
TitleStart parcel (flavor 20) |
|
|
The following parcel is repeated once for each column in WITH clause: |
|
|
Field parcel (flavor 18) |
|
|
TitleEnd parcel (flavor 21) |
|
|
FormatStart parcel (flavor 22) |
|
|
The following parcel is repeated once for each column in WITH clause: |
|
|
Field parcel (flavor 18) |
|
|
FormatEnd parcel (flavor 23) |
|
|
SizeStart parcel (flavor 24) |
|
|
The following parcel is repeated once for each column in WITH clause: |
|
|
Size parcel (flavor 26) |
|
|
SizeEnd parcel (flavor 25) |
|
|
EndWith parcel (flavor 35) |
|
|
The following parcels are repeated activity-count number of times |
|
|
RecStart parcel (flavor 27) |
|
|
The following parcel is repeated once for each column returned: |
|
|
Field parcel (flavor 18) |
|
|
RecEnd parcel (flavor 28) |
|
|
With parcel (flavor 33) |
|
|
RecStart parcel (flavor 27) |
|
|
The following parcel is repeated once for each column in WITH clause: |
|
|
Field parcel (flavor 18) |
|
|
RecEnd parcel (flavor 28) |
|
|
EndWith parcel (flavor 35) |
|
|
EndStatement parcel (flavor 11) |
|
|
EndRequest parcel (flavor 12) |
|
an ECHO request |
OK parcel (flavor 17) or StatementStatus (flavor 205) |
|
|
RecStart parcel (flavor 27) |
|
|
Field parcel (flavor 18) |
|
|
RecEnd parcel (flavor 28) |
|
|
EndStatement parcel (flavor 11) |
|
|
EndRequest parcel (flavor 12) |