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 .. 216 217 218 219 220 221 < 222 > 223 224 225 226 227 228 .. 241 >> Next

b 0x62 0x62 0x00 0x01
B 0x42 0x62 0x01 0x01
c 0x63 0x63 0x00 0x01
C 0x43 0x63 0x01 0x01
? 0xE7 0x63 0x02 0x01
<? 0xC7 0x63 0x03 0x01
d 0x64 0x64 0x00 0x01
D 0x44 0x64 0x01 0x01

For Japanese character support, MULTINATIONAL collation is single level.

The collation is entirely based on the equivalence-class and not on second -level comparisons.

During a multinational session, the Teradata RDBMS checks a system table for a row containing the value MULTINATIONAL in the CollName column. The hexadecimal codes in that row are used to determine the sort sequence for the session.

Teradata provides a set of objects in database DBC with which you can manipulate, build, and maintain codes for the various collation options for Multinational users. These objects include the following:

• A system table in which each row contains the definition of one collation sequence. (Note, however, that only one definition can be in effect at any given time.) The default collation will be based on the codes in the row where:

CollName=MULTINATIONAL and CollInstall=Y.

• A system view named DBC.Collations

Teradata RDBMS for UNIX SQL Reference

G-29
International and Japanese Character Support

Using Collation Sequences

User-defined collation codes should be inserted through this view to populate a row in the underlying system table. It is created with the clause GRANT SELECT TO PUBLIC to make it accessible to all Teradata RDBMS users.

• A system macro named DBC.CollInstallMulti

This macro is invoked by a privileged user to replace the current MULTINATIONAL collation with Teradata or user defined codes that have been loaded into a row of the system table.

A system restart is required before the new collation becomes the current MULTINATIONAL collation.

• A system macro named DBC.CollAddStandard

Privileged users can use this macro to reload the Teradata Standard Multinational sequence in the event the contents of the system table become corrupted. A system restart is required to change the current MULTINATIONAL collation.

Note: This macro is run automatically when the “dip” files are executed during the Teradata RDBMS installation procedure.

The rest of this section explains how to install and de-install the three standard collation sequences, and how to define your own collation sequence.

G-30

Teradata RDBMS for UNIX SQL Reference
International and Japanese Character Support

Changing the Standard Multinational Default Collation

Introduction

Procedure

Changing the Standard Multinational Default Collation

After the “dip” files have been run, a privileged user can execute the CollInstallMulti macro to change the default sequence for multinational collation. The EXECUTE privilege on this macro is initially assigned to system users SYSADMIN and DBC.

After the change is installed, the new ordering will be realized by the session of any user whose COLLATION attribute is MULTINATIONAL, or who submits the statement SET SESSION COLLATION MULTINATIONAL.

To change the Teradata Standard Multinational collation to the standard Swedish or Norwegian collation, perform the following procedure.

Step Action
1 Log on to a BTEQ session as user SYSADMIN or DBC.
2 Execute the DBC.CollInstallMulti macro, specifying the desired standard as the macro’s CollationName parameter. For example: EXECUTE DBC.CollInstallMulti ('NORWEGIAN_STANDARD'); or EXECUTE DBC.CollInstallMulti ('SWEDISH_STANDARD); or EXECUTE DBC.CollInstallMulti ('KANJI5026_STANDARD'); or EXECUTE DBC.CollInstallMulti ('KANJI5035_STANDARD'); or EXECUTE DBC.CollInstallMulti ('KANJIKATA_STANDARD');
3 On the Command Line of the DB window of the system console, enter the restart tpa command to restart the Teradata RDBMS.

During restart processing, Teradata displays a message indicating whether the specified collation sequence was installed.

Teradata RDBMS for UNIX SQL Reference

G-31
International and Japanese Character Support

Changing the Standard Multinational Default Collation

Deinstalling a NonStandard Collation

Example of Installing a Japanese Character Standard Collation

To de-install a non-standard collation and return to the Teradata Standard Multinational collation, perform the following procedure.

Step Action
1 Log on to a BTEQ session as system user SYSADMIN or DBC.
2 Either delete the row from DBC.Collations where CollName=MULTINATIONAL' or change to N (no) the value of the CollInstall column in the row where CollName=MULTINATIONAL'.
3 To reload the Teradata Standard Multinational collation, enter the following command to execute the DBC.CollAddStandard macro: EXECUTE DBC.CollAddStandard;
4 Restart the Teradata RDBMS.

You can also execute the DBC.CollAddStandard macro to reload the Teradata Standard Multinational collation if the contents of the system table become corrupted. (Remember to restart the Teradata RDBMS to register the codes.)

The following script is an example of de-installing and installing a standard Japanese character collation:
Previous << 1 .. 216 217 218 219 220 221 < 222 > 223 224 225 226 227 228 .. 241 >> Next