Input Data Formats
Table 1 lists the input data formats supported on UNIX and Windows platforms. Mainframes have standard records.
Data Format |
Description |
||
BINARY |
Specifies that each input record is a 2‑byte integer, n, followed by n bytes of data. |
||
FASTLOAD |
Specifies that each input record is a 2‑byte integer, n, followed by n bytes of data, followed by an end‑of‑record marker, either X'0A' or X'0D'. |
||
TEXT |
TEXT specifies that each record consists of an arbitrary number of characters in the client session character set, followed by an end‑of‑record marker, which is: For client session character sets other than UTF‑16, the end‑of‑record marker byte sequence is: For the UTF‑16 client session character set (in which each character is encoded in two bytes), the end‑of‑record marker byte sequence is:
|
||
UNFORMAT |
Specifies that each input record is defined by FIELD commands of the specified layout. |
||
VARTEXT |
Specifies that each variable‑length text record has each field separated by delimiter character(s). |
For a description of the supported input file formats, see the IMPORT Command description in Chapter 3: “Teradata TPump Commands.”