If the Teradata SQL statement was submitted in Indicator Mode (Response Mode = I), the response sequence for a successful statement will be as follows if the SQL statement is:
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)
Success parcel (flavor 8)
the activity code will reflect the number
of rows returned
DataInfo parcel (flavor 71)
Record parcels (flavor 10)
one record parcel for each row returned.
EndStatement parcel (flavor 11)
EndRequest parcel (flavor 12)
Success parcel (flavor 8)
activity count will reflect the number of
rows returned, including summary rows.
DataInfo parcel (flavor 71)
With parcel (flavor 33)
PosStart parcel (flavor 46)
Position parcel (flavor 34)
PosEnd parcel (flavor 47)
DataInfo parcel (flavor 71)
EndWith parcel (flavor 35)
Record parcel (flavor 10)
one record parcel for each row returned
With parcel (flavor 33)
one for each summary row
Record parcel (flavor 10)
EndWith parcel (flavor 35)
one for each summary row
EndStatement parcel (flavor 11)
EndRequest parcel (flavor 12)
Success parcel (flavor 8)
Record parcel (flavor 10) in record-mode format
EndStatement parcel (flavor 11)
EndRequest parcel (flavor 12)