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 .. 211 212 213 214 215 216 < 217 > 218 219 220 221 222 223 .. 241 >> Next


• Katakana characters and sound marks in single byte and multibyte forms.

• Hiragana characters.

• Kanji ideographs from JIS-x0208.

It is recommended that characters set names start with an unaccented uppercase Roman letter and consist only of unaccented uppercase Roman letters, digits, underscore, dollar sign, or number sign.

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

Columns in DBC. CharTranslations View

Inserting Code into DBC.CharTranslations

• CharSetID (TranslateID) BYTEINT NOT NULL

A number that uniquely identifies the character set for which these translation codes are being inserted. The number must be in the range 65-126.

• InstallFlag (Install) CHAR(1) NOT NULL

A Y (yes) or N (no) indicating whether the codes in this row are to be loaded by Teradata as one of the current character sets. A maximum of six character sets may be current at one time.

If more than six rows are flagged as Y at reset time, then the CharSetName values are sorted in ascending ASCII sequence, and the rows are loaded in alphabetical order until either the maximum of six is reached or the names are exhausted.

• E2I (TranslateIn) BYTE(256) NOT NULL

The external (host)-to-internal (Teradata) codes for each character in the set being defined.

• E2IUp (TranslateInUp) BYTE(256)

The external-to-internal uppercase codes for each character in the set being defined.

• I2E (TranslateOut) BYTE(256) NOT NULL

The internal (Teradata)-to-external (client) codes for each character in the set being defined.

• I2EUp (TranslateOutUp) BYTE(256) NOT NULL

The internal-to-external uppercase codes for each character in the set being defined.

Load the rows using the DBC.CharTranslations view using the following procedure.

Step Action
1 Log on to Teradata as system user DBC (or as any user with privileges to access and write to database DBC, such as system user SYSADMIN).
2 Verify that the DIPVIEWS RDBMSSQL file has been loaded into the DBC default database. This is usually done during the installation or initialization process. DIPVIEWS creates the system tables and user views for the Teradata Data Dictionary.

G-16

Teradata RDBMS for UNIX SQL Reference
International and Japanese Character Support

Columns in DBC. CharTranslations View

Loading Rows into DBC.HostsInfo View

Step Action
3 Verify that the Data Dictionary tables and views associated with International Character Support exist. To do this, submit the Teradata SQL request: HELP USER DBC; or HELP DATABASE DBC; The returned listing must include the following views: • CharSets • CharTranslations • HostsInfo
4 Use the Teradata SQL INSERT statement to load each defined character set. The definitions can be submitted using any convenient method, such as a BTEQ batch file similar to the one shown in the example below. Ensure that the client configuration matches the translation entry and table just created. See the section, “Example of Inserting the Swedish Character Set into DBC.CharTranslations”, for an example of inserting a character set into DBC.CharTranslations.

Using the Teradata SQL INSERT statement, load the rows into the DBC.HostsInfo view.

To register the defaults, do a COLD restart of the Teradata RDBMS.

During start-up, the character set name and identifier for each client system are sent to the appropriate TDP.

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

Example of Inserting the Swedish Character Set into DBC.CharTranslations

Example of Inserting the Swedish Character Set into DBC.CharTranslations

A BTEQ batch job used to insert a row defining the translation codes lntrodUction for a Finnish/ Swedish character set is shown in the following

example.

The external hexadecimal codes are EBCDIC and agree with Character Sequence Number 24 for an IBM 3270 Control Unit displaying to an IBM 3270 Information Display System.

Batch Job Code

/**************************************************************/ /* This is the Finnish/Swedish Character Set Codes for */

/* IBM 3270 information display system. The IBM manuals */

/* title "IBM 3270 Information Display System. 3270 Control */

/* Unit" and "IBM 3270 Information Display System. */

/* Character Set Reference". Document numbers GA23-0065-6 */

/* and GA27-2837-9 correspondingly. The sequence number */

/* for this character set is 24 - see 2-55 of GA23-0065-6 */

/* and 10-17 and 10-45 of GA27-2837-9. Here is the map */

/* between DBC and IBM character codes: */

/* */

/* Character Name DBC IBM */
/* HEX HEX */
/* */
/* Lowercase a with umlaut (diaresis). ..E4 C0 */
/* Uppercase A with umlaut (diaresis). ..C4 7B */
/* Lowercase a with ring ..E5 D0 */
/* Uppercase A with ring ..C5 5B */
/* Lowercase e with acute accent ..E9 79 */
/* Uppercase E with acute accent ..C9 E0 */
/* Lowercase o with umlaut (diaresis). .F6 05 */
Previous << 1 .. 211 212 213 214 215 216 < 217 > 218 219 220 221 222 223 .. 241 >> Next