Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS forUNIX SQL Reference - NCR

NCR Teradata RDBMS forUNIX SQL Reference - NCR, 1997. - 913 p.
Download (direct link): teradataforunix1997.pdf
Previous << 1 .. 224 225 226 227 228 229 < 230 > 231 232 233 234 235 236 .. 241 >> Next


• KANJISJIS_0S.

Besides ensuring that the HashFuncDBC field in the RDBMS Enabling Japanese Control Record has been correctly set as Kanji, users also need to

Characters perform all the following procedures and checks

• enable the use of external Japanese character sets, in order for the system to recognize your keyboard entry of Japanese characters.

This involves inserting and loading the correct character sets into the DBC.CharTranslations view. See later for details on how to achieve this.

G-56

Teradata RDBMS for UNIX SQL Reference
International and Japanese Character Support

Japanese Character Sites

• enable the graphic data type

• ensure that collation is single-level

• enable the internal Japanese character set.

This ensures that the Teradata RDBMS will be able to recognize and process object names and indexes, for example, which may be in Japanese characters.

Refer also to Chapter H, “Japanese Character Sets.”

Teradata RDBMS for UNIX SQL Reference

G-57
International and Japanese Character Support

Setting Up Japanese Character Support

Introduction

Setting Up Japanese Character Support

An installation script file, KANJINST, is provided on the release tape for a Japanese character site. The KANJINST script may need to be modified according to the site’s configuration. The KANJINST script is named according to the platform:

Platform Name of Script
VM file KANJINST DBCSQL
MVS member KANJINST in <dbcpfx>.APPDIPS
UNIX file KANJINST.BTEQ

UNIX users can find the KANJINST script in the TDBMS package. After you install TDBMS and have the system running with the provided TDBMS package, run the KANJINST.BTEQ script which is in the /tpasw/etc/directory of your UNIX machine.

KANJINST loads the Japanese character sets into a system table through the DBC.CharTranslations view.

Users need to determine what character set(s) need to be installed in their system and then turn on the INSTALLFLAG for the character set(s) in the DBC.CharTranslations view.

You must update DBC.HostsInfo if you also want to set client default assignments. After changing these settings, perform a TPARESET (RDBMS restart) to make them effective.

G-58

Teradata RDBMS for UNIX SQL Reference
International and Japanese Character Support

Setting Up Japanese Character Support

Channel-Attached Systems

You can establish a character set in one of the following ways, by order of precedence. A procedure for performing this is as follows.

Step Action

1 At start-up time in your application or utility program, specify the character set option in JCL from MVS or in your VM EXEC. This user-specified character set will override all other character sets previously specified or placed in default. See the appropriate utility manual for examples of MVS JCL or VM EXEC.

For FastLoad and BulkLoad, only step 1 applies. If a character set is not specified, then the default character set is EBCDIC for channel-attached systems and ASCII for network-attached systems.

2 Specify a character set value in the Host System Interface System Parameter Block (HSHSPB) module for IBM mainframes

To change the HSHSPB defaults, perform the following steps.

IF the site is . . . THEN set the HSHSPB IBOSCS parameter to . . .
Kanji N if the character set specified in the HSHSPB IBCCSN parameter (for example, IBCCSN=KATAKANAEBCDIC) is to be used When you do this, you must also add the IBCCSN line to HSHSPB ASSEMBLE under VM or to HSHSPB in <dbcpfx>.PROCLIB(TDU0007) under MVS. There is no dummy parameter in the file. If you edit HSHSPB, put an X in column 72 to indicate a continuation line.
non-Kanji Null (two single quotes)

If a character set has not been user-specified or specified in HSHSPB, then the default is the value in the system table, DBC.Hosts

If an application relies on the DBC.Hosts table for the default character set name, you must ensure that the initial logon from the IBM (channel-attached) side is in EBCDIC, and for all other platforms, in ASCII; otherwise, the default character set cannot be known to the application before logon.

3

Teradata RDBMS for UNIX SQL Reference G-59
International and Japanese Character Support

Setting Up Japanese Character Support

Network-Attached

Systems

You can establish a character set in one of the following ways, by order of precedence:

Step Action

1 Specify the character set option in your application or utility program. This user-specified character set will override all other character sets previously specified or placed in default.

For example, in the BTEQ and FastLoad utilities, use the .SET SESSION CHARSET command. See earlier and Teradata RDBMS for UNIX Support Utilities for examples of how to specify a character set.

2 Change the default in the clispb.dat file.

FOR this environment . . . Add the following lines to clispb.dat To indicate this character set . . .
UNIX CHARSET_TYPE=C CHARSET_ID=118 KANJIEUC_0U
Previous << 1 .. 224 225 226 227 228 229 < 230 > 231 232 233 234 235 236 .. 241 >> Next