Response parcels are generated by the 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 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 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. |