Request parcels are normally application's request. An application may generate all or some request parcels itself. All parcels may be generated by specifying a DBCAREA Request‑mode of B (commonly referred to as Buffer‑mode applications). Parcels may be added to those generated by CLIv2 by using a DBCAREA Initiate‑request extension (DBCAIRX).
Table 83 lists the request parcels by flavor, name, and use.
Flavor |
Parcel Name |
Use |
1 |
Req |
Initiates a request (Record Mode) |
3 |
Data |
Contains data for a Teradata SQL request (Record Mode) |
4 |
Respond |
Requests a portion up to 64K of a Teradata SQL response |
5 |
KeepRespond |
Requests a portion up to 64K of a Teradata SQL response without discarding it |
7 |
Cancel |
Discards those segments of a segmented data request that have already been sent |
13 |
FMReq |
Initiates a request (Field Mode) |
68 |
IndicData |
Contains data for a Teradata SQL request (Indicator Mode) |
69 |
IndicReq |
Initiates a request (Indicator Mode) |
71 |
DataInfo |
Sends description of whichever data parcel follows it |
85 |
Options |
Provides options for a request. |
120 |
CursorHost |
Provides cursor information. |
128 |
Multi‑TSR |
Segments special‑purpose requests into multiple parcels. |
129 |
SP Options |
Provides options for creation of a Stored Procedure. |
146 |
DataInfoX |
For MultipartIndicator mode responses, describes the data contained in subsequent MultipartRecord parcels. |
153 |
ExtendedRespond |
Requests a portion up to 2M of a Teradata SQL response |
154 |
ExtendedKeepRespond |
Requests a portion up to 2M of a Teradata SQL response without discarding it |
169 |
StatementInformation |
Describes the data items contained in the request when those attributes are not otherwise known. |
170 |
StatementInformationEnd |
Delimits StatementInformation parcels in the request. |
190 |
FetchRowCount |
Specifies the maximum number of rows to return in the response buffer |
215 |
SLOB Response |
Allows the Teradata Database to return data for a LOB inline based on specified limits |
220 |
SLOB DataStart |
Introduces SLOB Data parcels for a LOB |
221 |
SLOB Data |
Provides data for a LOB |
222 |
SLOB DataEnd |
Ends SLOB Data parcels for a LOB |