If the Teradata SQL statement is submitted in MultipartIndicator mode (Response-mode = M), the response parcels for a successful statement will be as follows:
| If the Teradata SQL statement is... | Then the response parcels are as follows... |
|---|---|
| non-data returning | Success parcel (flavor 8) 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 | Success parcel (flavor 8) or StatementStatus (flavor 205), the activity count will reflect the number of rows returned. |
| DataInfoX parcel (flavor 146) or StatementInformation (flavor 169) and StatementInformationEnd (flavor 170) | |
| The following parcel is repeated activity-count number of times: | |
| One or more MultipartRecord parcels (flavor 144) | |
| EndMultipartRecord parcel (flavor 145) | |
| EndStatement parcel (flavor 11) | |
| EndRequest parcel (flavor 12) | |
| a Select statement having one or more WITH clauses | Success parcel (flavor 8) or StatementStatus (flavor 205), the activity count will reflect the number of rows returned, including summary rows resulting from WITH clauses |
| DataInfoX parcel (flavor 146) or StatementInformation (flavor 169) and StatementInformationEnd (flavor 170) | |
| With parcel (flavor 33) | |
| PosStart parcel (flavor 46) | |
| Position parcel (flavor 34) | |
| PosEnd parcel (flavor 47) | |
| EndWith parcel (flavor 35) | |
| DataInfoX parcel (flavor 146) or StatementInformation (flavor 169) and StatementInformationEnd (flavor 170) | |
| The following parcels are repeated activity-count number of times: | |
| One or more MultipartRecord parcels (flavor 144) | |
| EndMultipartRecord parcel (flavor 145) | |
| The following parcels are repeated for each summary row: | |
| With parcel (flavor 33) | |
| One or more MultipartRecord parcels (flavor 144) | |
| EndMultipartRecord parcel (flavor 145) | |
| EndWith parcel (flavor 35) | |
| EndStatement parcel (flavor 11) | |
| EndRequest parcel (flavor 12) | |
| an ECHO request | Success parcel (flavor 8) or StatementStatus (flavor 205). |
| One or more MultipartRecord parcels (flavor 144) | |
| EndMultipartRecord parcel (flavor 145) | |
| EndStatement parcel (flavor 11) | |
| EndRequest parcel (flavor 12) |