Formatted Data - FastLoad

Teradata FastLoad Reference

Product
FastLoad
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-18
dita:mapPath
tjz1488824663315.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

Formatted data on network-attached systems is input data that conforms to the format of data from a Teradata Database source, such as a BTEQ EXPORT file.

Each record has the following:
  • A two-byte data length field
  • Optionally, a variable-length indicator bytes field
  • A variable-length input data field
  • A one-byte end-of-record delimiter field

The following table lists the formatted record field descriptions.

Formatted 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), and the last byte (the end-of-record 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
  • 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.

End-of-record The end-of-record delimiter field can be either of two hexadecimal values:
  • 0A (line feed)
  • 0D (carriage return)