Input Data Formats - Parallel Data Pump

Teradata® Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
dmq1512702641516.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following table lists the input data formats supported on UNIX and Windows platforms. Mainframes have standard records.

Teradata TPump Data Formats 
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:
  • On UNIX platforms, the newline character (identified in Unicode as LINE FEED U+000A)
  • On Windows platforms, the two-character sequence carriage return followed by line feed (identified in Unicode as CARRIAGE RETURN U+000D and LINE FEED U+000A, respectively)
For client session character sets other than UTF-16, the end-of-record marker byte sequence is as follows:
  • On UNIX platforms, X'0A'
  • On Windows platforms, X'0D0A'
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 as follows:
  • On big endian UNIX platforms, X'000A'
  • On little endian UNIX platforms, X'0A00'
  • On Windows platforms, X'0D000A00'
TEXT format should only be specified for character data. Do not specify TEXT format for binary data, such as, INTEGER, BYTEINT, PERIOD, and other binary data. Depending on the actual byte values of the binary data, unexpected results may occur.
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.