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 activitycount 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 activitycount 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) |