16.20 - Request 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

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). The following table 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 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