Issue with loading Trade mark data using TPT

Tools

Issue with loading Trade mark data using TPT

Hi All,

I am trying to load extended ASCII data (below is sample data) using TPT script, load is failing with "TPT10508: RDBMS error 6706: The string contains an untranslatable character." error, I have tried using CHARACTER SET UTF8, LATIN1_A0, LATIN1252_3A0 and LATIN1251_0A but failed with same error message.

Cool™ Start

Expect with ASCII, using CHARACTER SET ASCII I was able to load successfully but data looks garbage "Coolâ„¢ Start", does anybody have idea or know what is the correct character set to load extended ascii data or TPT doesn't support ascii data.

$ tbuild -f tbuild_tpt.txt

Teradata Parallel Transporter Version 13.00.00.00

Execution Plan generation started.

Execution Plan generation successfully completed.

Job log: /opt/teradata/client/13.0/tbuild/logs/srimitta-9.out

Job id is dsadm-9, running on ABC

Teradata Parallel Transporter SQL DDL Operator Version 13.00.00.00

DDL_OPERATOR: private log not specified

DDL_OPERATOR: connecting sessions

DDL_OPERATOR: sending SQL requests

DDL_OPERATOR: TPT10508: RDBMS error 6706: The string contains an untranslatable character.

DDL_OPERATOR: disconnecting sessions

DDL_OPERATOR: Total processor time used = '0.03 Second(s)'

DDL_OPERATOR: Start : Sun Jun  9 15:17:08 2013

DDL_OPERATOR: End   : Sun Jun  9 15:17:09 2013

Job step MAIN_STEP terminated (status 12)

Job dsadm terminated (status 12)

Thanks

Srini