About Specifying Source and Target Session Character Sets in a Job - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.00
Published
December 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
rdo1467305237457.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

Data Mover automatically chooses a default source and target session character set when creating or executing a job. The default session character set is ASCII, UTF8, or UTF16. The session character set chosen for each job is determined by the versions of the source and target systems and the characteristics of the objects being copied. Choosing a different source and target session character set is useful when the object names or data were originally created using a different session character set than any of the default values. For example, if data was originally inserted into the source table using KANJISJIS_0S as the session character set, you would want to specify KANJISJIS_0S as the source and target session character set when copying the data using Data Mover.

Data Mover supports specifying all of the session character sets supported by the Teradata JDBC driver as follows:

  • ASCII
  • UTF8
  • UTF16
  • KANJIEBCDIC5026_0I
  • KANJIEBCDIC5035_0I
  • KANJIEUC_0U
  • KANJISJIS_0S
  • EBCDIC037_0E
  • EBCDIC273_0E
  • EBCDIC277_0E
  • HANGULEBCDIC933_1II
  • HANGULKSC5601_2R4
  • LATIN1_0A
  • LATIN1252_0A
  • LATIN9_0A
  • SCHEBCDIC935_2IJ
  • SCHGB2312_1T0
  • TCHBIG5_1R0
  • TCHEBCDIC937_3IB

Data Mover does not support user defined session character sets or the 12 Teradata Database session character sets that the JDBC driver currently does not support. This is due to the fact that Data Mover cannot execute any queries on the source or target system if using any of these character sets.

The session character sets can be specified for both the source and target system in the job definition as follows:

<source_tdpid>hummingbird</source_tdpid>
<source_user>dmguest</source_user>
<source_password>dmguest</source_password>
<source_session_charset>KANJIEUC_0U</source_session_charset>
<target_tdpid>apollo</target_tdpid>
<target_user>dmguest</target_user>
<target_password>dmguest</target_password>
<target_session_charset>KANJIEUC_0U</target_session_charset>