Graphic Data Types - Parallel Data Pump

Teradata® Parallel Data Pump Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Data Pump
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-11-17
dita:mapPath
kpf1641281806652.ditamap
dita:ditavalPath
ovd1619195504008.ditaval
dita:id
ouq1478611619316
Product Category
Teradata Tools and Utilities

To define double-byte character set data, the GRAPHIC, VARGRAPHIC, and LONG VARGRAPHIC data types are supported. Teradata TPump accepts GRAPHIC data in the input data set or file containing the Teradata TPump statements to be executed.

The FIELD and FILLER statements that describe the input data are the statements affected by GRAPHIC data support. The following table lists the GRAPHIC data types that can be specified for the datadesc option in the FIELD or FILLER statement.

GRAPHIC Data Types for datadesc option in FIELD or FILLER Statement 
GRAPHIC Data Type Input Length Description
GRAPHIC (n) if n specified, (n*2) bytes; otherwise, 2 bytes (n=1 is assumed) n double-byte characters
VARGRAPHIC (n) m+2 bytes where m/2 <= n 2-byte integer, followed by m/2 double-byte characters
LONG VARGRAPHIC m+2 bytes where m/2 <=32000 2-byte integer, followed by m/2 double-byte characters