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

Purpose

The Data parcel sends data in Record Mode to 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.