DataInfo - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
lvt1544831946862.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

Returns a description of the items within the Data Field of the corresponding Indicator Mode Record parcels.

Usage Notes

DataInfo parcel is not returned if the statement was an ECHO statement. This parcel is generated by the database.

Parcel Data

Flavor Parcel Body Length Parcel Body Fields
71 6 to maximum body size FieldCount:   2 bytes
Pair 1:

Data Type:

Length:

2 bytes

2 bytes

 .

 .

 .

   
Pair i:

Data Type:

Length:

2 bytes

2 bytes

 .

 .

 .

   
Pair n:

Data Type:

Length:

2 bytes

2 bytes

Field Notes

The following notes apply to the Fields for the DataInfo parcel.

  • The FieldCount, n, is the number of items within the Data Field in the corresponding Indicator Mode Record parcels. It also is the number of data type and length pairs in this DataInfo parcel.
  • The Pair fields contains a description of the data type and length of the corresponding data item of the record parcel. That is, the ith pair of data type and length values in the DataInfo parcel corresponds to the ith data item in the Data Field of the Indicator Mode Record parcel. See Data Type for the possible data types.
    • If the data type of the ith data item is not decimal, then the length (maximum length for VARBYTE and VARCHAR) of the ith data item in the Indicator Mode Record parcel is represented in the DataInfo parcel as a 16-bit signed binary.
    • If the data type of the ith data item is decimal, then the total number of digits in the ith data item in the Indicator Mode Record parcel is represented in the DataInfo parcel in the first byte of the parcel body length as an 8-bit signed binary, and the number of fractional digits is represented in the second byte of the parcel body length as an 8-bit signed binary.