Data - Teradata Tools and Utilities

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Tools and Utilities
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-11-17
dita:mapPath
oxw1641281447623.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
vfj1470443597526
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

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