Description - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
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
  • Note: 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