16.20 - Response Parcels: Overview - 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

Response parcels are generated by the Teradata Database in response to an application's request. Not every parcel appears in every response.

The following table lists the response parcels by flavor, name, use, length, and the names of fields contained in the parcel body.

Flavor Parcel Name Use
8 Success Indicates that the specified Teradata SQL statement completed successfully in other than Field Response-mode when using Original Statement-status.
9 Failure Indicates that the specified statement has failed and the entire transaction was rolled back.
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 (Field Mode) in Field Response-mode when using Original Statement-status.
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, when Return-statement-info 'Y' was not specified.
34 Position Specifies the column number being summarized, when Return-statement-info 'Y' was not specified.
35 EndWith Delimits the end of a set of parcels for the specified WITH clause, when Return-statement-info 'Y' was not specified.
46 PosStart Delimits the start of a set of Position parcels, when Return-statement-info 'Y' was not specified.
47 PosEnd Delimits the end of a set of Position parcels, when Return-statement-info 'Y' was not specified.
49 Error Indicates that the specified statement has an error not serious enough to cause rollback.
71 DataInfo Returns a description of the following Indicator Mode Record parcels, when Return-statement-info 'Y' was not specified.
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, when Return-statement-info 'Y' was not specified.
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 MultiportIndicator, when Return-statement-info 'Y' was not specified.
144 MultipartRecord For MultipartIndicator mode responses, returns one row or part of one row of selected results.
145 EndMultipartRecord For MultipartIndicator mode responses, delimits one row or selected results.
146 DataInfoX For MultipartIndicator mode responses, describes the data contained in subsequent MultipartRecord parcels, when Return-statement-info 'Y' was not specified.
150 ElicitData For MultipartIndicator mode responses, elicits a deferred MultipartIndicator Response-mode large object.
151 ElicitFile For MultipartIndicator mode responses, elicits a User Defined Function.
152 ElicitDataReceived For MultipartIndicator mode responses, indicates that an elicited data or file was successfully received.
164 ErrorInformation After an Error parcel (flavor 49), provides additional information about the error
169 StatementInformation Returns a description of the data, when Return-statement-info 'Y' was specified.
170 StatementInformationEnd Delimits related StatementInformation parcels.
171 ResultSummary Indicates that the specified Teradata SQL statement completed successfully when using Enhanced Statement-status.
172 ResultSet Introduce parcels returned from a CALLed stored procedure.
176 ElicitDataByName For MultipartIndicator mode responses, elicits a deferred large object by its specified name.
192 StatementError Indicates a statement in a multi-statement request encountered a problem but the transaction is not rolled back.
205 StatementStatus Indicates that the specified Teradata SQL statement completed.