16.20 - Submitting Requests In Field Mode - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

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)