Data - 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

Purpose

The Data parcel sends data in Record Mode to the Teradata Database. The Data parcel follows either a Req, IndicReq, or FMReq parcel that contains a USING row descriptor.

Usage Notes

This parcel is generated by CLIv2 at the direction of the application.

Parcel Data

The following table lists field information for the Data parcel.

Flavor Field Parcel Body Length Parcel Body Fields
3 1 to maximum body size Data: 1 to maximum body size bytes
A maximum parcel body size of 65024 bytes is only approached with the Archive/Recovery utility. The maximum size of a regular SQL parcel body is 64256 bytes, including overhead such a presence bits and variable length columns.

Fields

The Data field contains a formatted record of data.

  • The order of the items and their data types and lengths are determined by the USING row descriptor in the Teradata SQL statement.
  • The values of the items are represented in a client internal format for details. See the table titled Data Type Values.
  • A null value is implicitly indicated by a specific value of the item and that value is not necessarily unique to null. For explicit, unique indications of null values, use Indicator Mode or Field Mode.