SET CHARSET - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
pxm1544831938750.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2416
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

Establishes the character set with which userids (SET USERID) and logon strings (START POOL) are specified in TDP commands.

Syntax



The SE abbreviation is deprecated.

where:

character_set_name
The name of a character set known to TDP, chosen as one of the following, having EBCDIC characteristics:
  • EBCDIC
  • EBCDIC037_0E
  • EBCDIC273_0E
  • EBCDIC277_0E
  • HANGULEBCDIC933_1II
  • KANJIEBCDIC5026_0I
  • KANJIEBCDIC5035_0I
  • KATAKANAEBCDIC
  • SCHEBCDIC935_2IJ
  • TCHEBCDIC937_3IB
Or one of the following, having ASCII characteristics:
  • ARABIC1256_6A0
  • ASCII
  • CYRILLIC1251_2A0
  • HANGUL949_7R0
  • HANGULKSC5601_2R4
  • HEBREW1255_5A0
  • KANJIEUC_0U
  • KANJISJIS_0S
  • LATIN1_0A
  • LATIN1250_1A0
  • LATIN1252_0A
  • LATIN1252_3A0
  • LATIN1254_7A0
  • LATIN1258_8A0
  • LATIN9_0A
  • SCHGB2312_1T0
  • SCHINESE936_6R0
  • TCHBIG5_1R0
  • TCHINESE950_8R0
  • THAI874_4A0
  • UTF8
Or UTF16 or any user-defined character set established using the TDP SET USERCS command.

While other names can be specified, their characteristics (codepoint for the space, comma, apostrophe, and quotation symbols; the codepoints for control characters; the encoding scheme, and the rules for monocasing) are assumed to be the same as the characteristics for EBCDIC.

Usage Notes

Unless this command is specified, EBCDIC is assumed. Neither the ability of the database to support character sets nor the existence of the specified character set is validated during the execution of this command. Subsequent attempts to specify a database object in a TDP command can result in errors.

The current character set can be displayed using the DISPLAY TDP command.

Example 1: SET CHARSET

SET CHARSET KANJIEBCDIC5026_0I

Example 2: SET CHARSET

SET CHARSET EBCDIC

Completion Message

TDP0396 TDP CHARSET IS NOW character_set_name

Error Messages

Possible error messages are:

TDP0504 UNKNOWN TDP COMMAND NAME: text
TDP0506 UNKNOWN OPERAND TO THE ‘SET’ COMMAND: text
TDP0535 TOO FEW OPERANDS FOR THE ‘SET CHARSET’ COMMAND
TDP0536 TOO MANY OPERANDS FOR THE ‘SET CHARSET’ COMMAND
TDP0502 LENGTH INCORRECT FOR ‘SET CHARSET’ VALUE