Table 10 following table lists the response parcels by flavor, name, and use.
Flavor |
Parcel Name |
Use |
8* |
Success |
Indicates that the specified Teradata SQL statement completed successfully in other than Field Response-mode. When the response is for a session that specified a SessionOptions parcel (described in “SessionOptions” on page 296) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Table 8 on page 275) may be returned instead. |
9* |
Failure |
Indicates that the specified statement has failed and the entire transaction was rolled back. When the response is for a session that specified a SessionOptions parcel (described in “SessionOptions” on page 296) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Table 8 on page 275) may be returned instead. |
10* |
Record (Record Mode) |
Returns one row of selected results. |
10* |
Record (Indicator Mode) |
Returns one row of selected results. |
11* |
EndStatement |
Delimits the end of the results from the specified Teradata SQL statement. |
12* |
EndRequest |
Delimits the end of a Teradata SQL response to a Teradata SQL request. |
17* |
Ok |
Indicates that the specified Teradata SQL statement completed successfully in Field Response-mode. When the response is for a session that specified a SessionOptions parcel (described in “SessionOptions” on page 296) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Table 8 on page 275) may be returned instead. |
18* |
Field |
Contains returned information (data value, title, format, or echo). |
19* |
NullField |
Returns a null data value for a field. |
20* |
TitleStart |
Delimits the start of a set of Title parcels. |
21* |
TitleEnd |
Delimits the end of a set of Title parcels. |
22* |
FormatStart |
Delimits the start of a set of format‑containing Field parcels. |
23* |
FormatEnd |
Delimits the end of a set of format‑containing Field parcels. |
24* |
SizeStart |
Delimits the start of a set of Size parcels. |
25* |
SizeEnd |
Delimits the end of a set of Size parcels. |
26* |
Size |
Specifies the width of a column of selected results. |
27* |
RecStart |
Delimits the start of a set of data‑value-containing Field and Null‑Field parcels or a set of echoed string‑ containing Field parcels. |
28* |
RecEnd |
Delimits the end of a set of data‑value-containing Field and Null‑Field parcels or a set of echoed string‑containing Field parcels. |
33* |
With |
Delimits the start of a set of parcels for the specified WITH clause. |
34* |
Position |
Specifies the column number being summarized. |
35* |
EndWith |
Delimits the end of a set of parcels for the specified WITH clause. |
46* |
PosStart |
Delimits the start of a set of Position parcels. |
47* |
PosEnd |
Delimits the end of a set of Position parcels. |
49* |
Error |
Indicates that the specified statement has an error not serious enough to cause rollback. When the response is for a session that specified a SessionOptions parcel (described in “SessionOptions” on page 296) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Table 8 on page 275) may be returned instead. |
71* |
DataInfo |
Returns a description of the following Indicator Mode Record parcels. |
86* |
PrepInfo |
Returns column information from the Teradata Database when a Teradata SQL statement has been sent with a Request Processing Option of Prepare and a Response Mode of Indicator. |
121* |
CursorDBC |
Returns cursor information. |
122* |
Flagger |
Returns language non-conformances. |
125* |
PrepInfoX |
Returns column information from the Teradata Database when a Teradata SQL statement has been sent with a Request Processing Option of Prepare and a Response Mode of Extended. |
137 |
UserNameResponse |
Returns the userid assigned to the session. |
144* |
MultipartRecord |
Returns selected results (Multipart mode). |
145* |
EndMultipartRecord |
Indicates end of selected results for one row (Multipart mode). |
146* |
DataInfoX |
Returns a description of subsequent parcels (Multipart mode). |
150* |
ElicitData |
Indicates that data must be supplied. |
151* |
ElicitFile |
Indicates that the contents of a file must be supplied. |
152* |
ElicitDataReceived |
Indicates that elicited data was received by the Teradata Database. |
164* |
ErrorInformation |
After an Error parcel (flavor 49), provides additional information about the error. When the response is for a session that specified a SessionOptions parcel (described in “SessionOptions” on page 296) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Table 8 on page 275) may be returned instead. |
169* |
StatementInformation |
Returns a description of the data, when the Options parcel (flavor 85 in Table 9) specifies Return-statement-info (corresponding to the CLIv2 DBCAREA Return-statement-info option) |
170* |
Statement InformationEnd |
Delimits related StatementInformation parcels. |
172* |
ResultSet |
Introduce parcels returned from a CALLed stored procedure |
176* |
ElicitDataByName |
Indicates that data must be supplied for the specified name. |
192* |
StatementError |
Indicates a statement in a multi-statement request encountered a problem but the transaction is not rolled back. When the response is for a session that specified a SessionOptions parcel (described in “SessionOptions” on page 296) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Table 8 on page 275) may be returned instead. |
205* |
StatementStatus |
Indicates that the specified Teradata SQL statement completed. |
220* |
SLOB DataStart |
Introduces SLOB Data parcels. |
221* |
SLOB Data |
Provides data for a LOB. |
222* |
SLOB DataEnd |
Ends SLOB Data parcels for a LOB. |
* Parcel is described in Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems (B035-2417). |