These parcels are generated by the database. The application program can see all of them directly.
The following table lists the response parcels in numerical order.
Parcel Flavor | Parcel Name | Parcel Use | Parcel Length | Fields in Parcel Body |
---|---|---|---|---|
8 | Success | Indicates that the specified Teradata SQL statement completed successfully | 18-273 |
|
9 | Failure | Indicates that the specified statement has a failed and the entire transaction was rolled back | 13-267 |
|
10 | Record | Returns one row of selected results | 5-32004/65104 | Data |
11 | EndStatement | Delimits the end of the results from the specified Teradata SQL statement | 6 | StatementNo |
12 | EndRequest | Delimits the end of a Teradata SQL response to a DBC/SQL request | 4 | None |
17 | Ok | Indicates that the specified Teradata SQL statement completed successfully | 18-273 |
|
18 | Field | Contains returned information (data value, title, format, or echo) | 4-32004/65104 | Data |
19 | NullField | Returns a null data value for a field | 4 | None |
20 | TitleStart | Delimits the start of a set of format-containing Field parcels | 4 | None |
21 | TitleEnd | Delimits the end of a set of format-containing Field parcels | 4 | None |
22 | FormatStart | Delimits the start of a set of format-containing Field parcels | 4 | None |
23 | FormatEnd | Delimits the end of a set of format-containing Field parcels | 4 | None |
24 | SizeStart | Delimits the start of a set of Size parcels | 4 | None |
25 | SizeEnd | Delimits the end of a set of Size parcels | 4 | None |
26 | Size | Specified the width of a column of selected results | 4 | MaxFldSize |
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 | 4 | None |
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 | 4 | None |
32 | NOP | Sends test messages to make sure the connection is still alive. | 4 | None |
33 | With | Delimits the start of a set of parcels for the specified WITH clause | 6 | WithId |
34 | Position | Specifies the column number being summarized | 6 | ColumnNo |
35 | EndWith | Delimits the end of a set of parcels for the specified WITH clause | 6 | WithId |
46 | PosStart | Delimits the start of a set of Position parcels | 3 | None |
47 | PosEnd | Delimits the end of a set Position parcels | 4 | None |
49 | Error | Indicates that the specified statement has an error not serious enough to cause rollback | 13-267 |
|
71 | DataInfo | Returns a description of the following Indicator Mode Record parcels | 6-32004/65104 | FieldCount Pairs: Length Type |
86 | PrepInfo | Returns column information to the database when a Teradata SQL statement has been prepared using the Request Processing Option. | 16 to 32004/65104 | None |
101 | AssignRsp | Assigns a session COP by returning the information needed for the workstation to connect to the database. | 76 |
|
121 | CursorDBC | Returns cursor information. | 14 | Processor Row |
122 | Flagger | Returns language nonconformances. | 10 to 32004/65104 | Flags |
164 | ErrorInformation | After an Error parcel (flavor 49), provides additional information about the error. | 1 to maximum parcel size |
|
169 | StatementInformation | Returns a description of the data, when Return-statement_info ‘Y’ was returned. | 6 to maximum parcel size |
|
170 | StatementInformationEnd | Delimits related StatementInformation parcels. | 0 | none |
172 | ResultSet | Introduce parcels returned from a CALLed stored procedure. | 12 |
|
192 | StatementError | Provides independent statement errors for multi-statement requests. | 12 to 271 |
|
205 | StatementStatus | Functionally replaces Success and OK parcels to provide 8-byte activity count. | 32 to maximum parcel size |
|