If the Teradata SQL statement is submitted in Record Mode (Response Mode = R), the response parcels for a successful statement will be as follows.
If the SQL statement is:
- A non-data returning statement
Success parcel (flavor 8) 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)
- A data returning statement or SELECT statement with no WITH clause
Success parcel (flavor 8) the activity code will reflect the number of rows returned Record Parcel (flavor 10) one record parcel for each row returned EndStatement parcel (flavor 11) EndRequest parcel (flavor 12)
- A SELECT statement having one or more WITH clauses
Success parcel (flavor 8) the activity code will reflect the number of rows returned, including the summary rows Record Parcel (flavor 10) one record parcel for each row returned, including the summary rows EndStatement parcel (flavor 11) EndRequest parcel (flavor 12) With parcel (flavor 33) one for each summary row immediately preceding the Record parcel containing the summary row. EndWith parcel (flavor 35) one for each summary row immediately following the Record parcel containing the summary row.
- An ECHO request
Success parcel (flavor 8) Record parcel (flavor 10) EndStatement parcel (flavor 11) EndRequest parcel (flavor 12)