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


The value in this column must be the same as the identifier established for this connection by the hardware configuration data.

HostName CHAR(30) NOT NULL

An arbitrary, user-assigned name for this host (for example: VM, VAX1, OsloLAN, and so forth).

DefaultCharSet CHAR(30)

The name of the translation codes to be used by default when passing data to and from this client. This value may be one of the following:

EBCDIC (IBM mainframe client)

ASCII (any other client)

The TranslateName assigned to a set of translation codes in the DBC.CharTranslations view

Teradata RDBMS for UNIX SQL Reference

G-21
International and Japanese Character Support

Installing Character Sets

Installing Character Sets

To install the contents of the system tables, enter the restart tpa command in the Command Line of the DB window of the system console. This invokes a full restart of the Teradata RDBMS.

During restart, a maximum of six rows in the DBC. CharTranslations view containing a Y in the InstallFlag field, will be loaded. Each row will become an available character set.

If DBC.HostsInfo contains rows, the default character set assignments will be identified to the appropriate TDP(s).

The example in Figure G-2, below, shows the contents of populated DBC.CharTranslations and DBC.HostsInfo views. The SELECT statements were submitted via an interactive BTEQ session.

The example character set names were intended to be meaningful to users. They indicate the language of the character set and the external (client) code type. For example, they all include EBCDIC to indicate that the client is a channel-attached IBM system.

If the character sets were for a LAN-attached client, the names could have been defined as German_ASCII, Spanish_ASCII, and so forth.

SELECT * FROM DBC.CharTranslations;

*** Query completed. 6 rows found. 7 columns returned. *** Time was 3.6 0 seconds.

CharSetName CharSetId InstallFlag E2I

German_EBCDIC 100 Y 0 0 0102 03A8 0 9A97FD1D2D3
Spanish_EBCDIC 105 Y 0 0 0102 03A8 0 9A97F2 3 95EE
French_EBCDIC 103 Y 0 0 0102 03A8 0 9A97FD1D2D3
Italian_EBCDIC 104 Y 0 0 0102 03A8 0 9A97FD1D2D3
C I D C B E n_E a i g e w r o N 101 Y 0 0 0102 03 8D0 9A97FD1D2D3
SWEDISH EBCDIC 102 Y 0 0 0102 03 8D0 9A97FD1D2D3

SELECT * FROM DBC.HostsInfo;

*** Query completed. One row found. 3 columns returned. *** Time was 2.14 seconds.

LogicalHostId HostName DefaultCharSet

136 VM SWEDISH EBCDIC

Figure G-2

Example Views of Populated Translation and Host Tables

G-22

Teradata RDBMS for UNIX SQL Reference
International and Japanese Character Support

Teradata Internal Form for International Character Support

Teradata Internal Form for International Character Support

For International character support, the Teradata RDBMS stores data internally in an extended ASCII as defined in the following table, Table G-1.

Teradata RDBMS for UNIX SQL Reference

G-23
International and Japanese Character Support

Teradata Internal Form for International Character Support

Table G-1

Teradata Internal Form for International Character Support

Code Char Character Name Code Char Character Name
00 NUL Null character 30 0 Zero
01 SOH Start of heading 31 1 One
02 STX Start of text 32 2 Two
03 ETX End of text 33 3 Three
04 EOT End of Transmission 34 4 Four
05 ENQ Enquiry 35 5 Five
06 ACK Acknowledge 36 6 Six
07 BEL Bell 37 7 Seven
08 BS Backspace 38 8 Eight
09 HT Horizontal tabulation 39 9 Nine
0A LF Line feed 3A Colon
0B OB Vertical tabulation 3B Semicolon
0C FF Form feed 3C < Less than
0D CR Carriage return 3D = Equal to
0E SO Shift out 3E > Greater than
0F SI Shift in 3F ? Question mark
10 DLE Data link escape 40 @ Commercial at
11 DC1 Device control 1 41 A Uppercase A
12 DC2 Device control 2 42 B Uppercase B
13 DC3 Device control 3 43 C Uppercase C
14 DC4 Device control 4 44 D Uppercase D
15 NAK Negative acknowledge 45 E Uppercase E
16 SYN Synchronous idle 46 F Uppercase F
17 ETB End of transmission block 47 G Uppercase G
18 CAN Cancel 48 H Uppercase H
19 EM End of medium 49 I Uppercase I
1A SUB Substitute 4A I Uppercase J
1B ESC Escape 4B K Uppercase K
1C FS File separator 4C L Uppercase L
1D GS Group separator 4D M Uppercase M
1E RS Record separator 4E N Uppercase N
1F US Unit separator 4F O Uppercase O
20 SP Space 50 P Uppercase P
21 ! Exclamation point 51 Q Uppercase Q
22 Double quotation mark 52 R Uppercase R
23 # Number sign 53 S Uppercase S
24 $ Dollar sign 54 T Uppercase T
25 % Percent sign 55 U Uppercase U
26 & Ampersand 56 V Uppercase V
27 apostrophe (single quote) 57 W Uppercase W
28 ( Opening parenthesis 58 X Uppercase X
29 ) Closing parenthesis 59 Y Uppercase Y
2A * Asterisk 5A Z Uppercase Z
2B + Plus 5B [ Opening bracket
2C , Comma 5C \ Backslash
2D - Hyphen or minus 5D I Closing bracket
2E Period or decimal point 5E Circumflex
2F / Slash 5F Underline (underscore)
Previous << 1 .. 213 214 215 216 217 218 < 219 > 220 221 222 223 224 225 .. 241 >> Next