15.00 - Input Data Formats - Parallel Data Pump

Teradata Parallel Data Pump Reference

prodname
Parallel Data Pump
vrm_release
15.00
category
Programming Reference
featnum
B035-3021-034K

Input Data Formats

Table 1 lists the input data formats supported on UNIX and Windows platforms. Mainframes have standard records.

 

Table 1: Teradata TPump Data Formats 

Data Format

Description

BINARY

Specifies that each input record is a 2byte integer, n, followed by n bytes of data.

FASTLOAD

Specifies that each input record is a 2byte integer, n, followed by n bytes of data, followed by an endofrecord 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 endofrecord marker, which is:

  • On UNIX platforms, the newline character (identified in Unicode as LINE FEED U+000A)
  • On Windows platforms, the twocharacter 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 UTF16, the endofrecord marker byte sequence is:

  • On UNIX platforms, X'0A'
  • On Windows platforms, X'0D0A'
  • For the UTF16 client session character set (in which each character is encoded in two bytes), the endofrecord marker byte sequence is:

  • On big endian UNIX platforms, X'000A'
  • On little endian UNIX platforms, X'0A00'
  • On Windows platforms, X'0D000A00'
  • Notice:

    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 variablelength 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.”