Binary Data

Teradata FastLoad Reference

Product

FastLoad

Release Number

15.00

Language

English (United States)

Last Update

2018-09-28

dita:id

B035-2411

lifecycle

Product Category

Teradata Tools and Utilities

The binary data format is a 2‑byte integer, n, followed by n bytes of data. Binary data format is similar to formatted data format, except that there is no end‑of‑record marker.

Each record has:

A two‑byte data length field

Optionally, a variable‑length indicator bytes field

A variable‑length input data field

Table 3 lists the unformatted binary record field descriptions.

Table 3: Binary Record Field Descriptions
Input Record Field	Description
Data length	A two‑byte field indicating the total length of the record, in bytes, excluding the first two bytes (this field) The data length must be specified as an explicit value, not an ASCII value. For a data length of one byte, for example, the specification must be hexadecimal 01. It cannot be hexadecimal 31, or the ASCII equivalent of the number 1.
Indicator bytes	Optional bytes to indicate null data
Input data	The actual input data for rows in the Teradata FastLoad table. The input data stream always starts at either: The third byte of the record, if there are no optional indicator bytes or Immediately after the last optional indicator byte The length of the input data field, less any optional indicator bytes, is as specified in the first two bytes.