Specifying Data Types - Parallel Data Pump

Use the datadesc parameter to specify the type and length of data in the field. Teradata TPump generates the USING phrase accordingly with the user-assigned field name to which the body of the DML statement refers.

For complete details on data types and data conversions, see Teradata Vantage™ - Data Types and Literals, B035-1143.

The following is a short list of the input length and field description for the data type specifications which can be made in the datadesc parameter:

Graphic Data Type Specifications

GRAPHIC(n)

Where n is the length of the input stream in terms of double-byte characters.

Length: n*2 bytes, if n is specified; otherwise 2 bytes, as n=1 is assumed.

Description: n double-byte characters.

The following example illustrates the use of the GRAPHIC data types in support of kanji or multibyte character data. The FIELD statement can contain GRAPHIC data types.

.LAYOUT KANJIDATA;
.FIELD EMPNO   * SMALLINT;
.FIELD LASTNAME  * GRAPHIC(30);
.FILLER FIRSTNAME * GRAPHIC(30);
.FIELD JOBTITLE  * VARGRAPHIC(30);

VARGRAPHIC(n)

Where n is the length of the input stream in terms of double-byte characters.

Length: m + 2 bytes where m/2 ≤ 32000.

Description: 2-byte integer followed by m/2 double-byte characters.

LONG VARGRAPHIC

Length: m + 2 bytes where m/2 ≤ 32000.

Description: 2 byte integer followed by m/2 double-byte characters.