Description of the Kanji Character Set | Basic Teradata Query - Description of the Kanji Character Set - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
nnw1608578382132.ditamap
dita:ditavalPath
obe1474387269547.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