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) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Parcel Flavors) 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) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Parcel Flavors) 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) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Parcel Flavors) 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) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Parcel Flavors) may be returned instead. |
71* | DataInfo | Returns a description of the following Indicator Mode Record parcels. |
86* | PrepInfo | Returns column information from the 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 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 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) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Parcel Flavors) may be returned instead. |
169* | StatementInformation | Returns a description of the data, when the Options parcel (flavor 85 in Request Parcels: Overview) 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) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Parcel Flavors) 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. |