17.00 - Specifying Data Types - Parallel Data Pump

Teradata® Parallel Data Pump Reference

prodname
Parallel Data Pump
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-3021-220K

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.

  • For both VARGRAPHIC and LONG VARGRAPHIC, m, a value occupying the first 2 bytes of the input data, is the length of the input in bytes, not characters. Each multibyte character set character is 2 bytes.
  • LONG VARGRAPHIC also implies VARGRAPHIC (32000). Range is 0 to 32000 in a 64,000-byte field.