Formatted data on workstation-attached systems is input data that conforms to the format of data from a 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.
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 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:
|