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