Description of the Kanji Character Set - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-02-20
dita:mapPath
kil1527114222313.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

To correctly display Katakana and double-byte data on z/OS, enter data using PDF/EDIT, and view the output with PDF/BROWSE.

BTEQ has no special handling for the extra spaces required for the SO/SI characters (that is, Shift-Out/Shift-In).

Be aware that lowercase English letters are not allowed when using the KATAKANAEBCDIC or KANJIEBCDIC5026_0I character sets.

If your BTEQ job contains lowercase English characters, it can be executed using one of the character sets that supports lowercase Latin letters, such as the following:

  • KANJIEBCDIC5035_0I
  • EBCDIC
If the job contains only uppercase English characters, it can be executed using any character set.

For KATAKANAEBCDIC, BTEQ displays all output in uppercase Latin characters, except for the following:

  • response data
  • user comments
  • NULL strings
  • SEPARATOR strings