Request Parcels: Overview - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

Product
Call-Level Interface Version 2
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-07
dita:mapPath
jen1488824663137.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.

Request Parcel Flavors, Names, And Uses
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