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 .. 203 204 205 206 207 208 < 209 > 210 211 212 213 214 215 .. 241 >> Next


COMMENT ON Personnel.Employee.Name 'Emp name: last name and first initial.';

COMMENT ON Personnel.Employee.DeptNo 'Department number of employee.'; COMMENT ON Personnel.Employee.JobTitle 'Employee''s title or position.';

COMMENT ON Personnel.Employee.salary 'Annual base salary.';

COMMENT ON Personnel.Employee.YrsExp 'Years of applicable job experience.';

COMMENT ON Personnel.Department 'Departmental Data.';

An example of typical data in the personnel.Charges table is:

Employee ID

Project ID

Week Ending

Hours

10015

10010

10001

AP2-0002

ENG-0 0 04

ENG-0 0 02

96/09/06

96/09/06

96/08/02

23.0

30.5

12.5

Teradata RDBMS for UNIX SQL Reference

D-3
Sample Personnel Database

Personnel Database

D-4

Teradata RDBMS for UNIX SQL Reference
ASCII Hexadecimal Translation Tables

Appendix E

ASCII Hexadecimal Translation Tables

Teradata RDBMS for UNIX SQL Reference
ASCII Hexadecimal Translation Tables

Teradata RDBMS for UNIX SQL Reference
ASCII Hexadecimal Translation Tables

About This Appendix

About This Appendix

This appendix shows the hexadecimal representations used by the Teradata RDBMS to translate standard (English language) characters from EBCDIC to ASCII and from ASCII to EBCDIC. It also shows the internal ASCII hexadecimal representations of the supported Multinational (diacritical) characters.

The EBCDIC to ASCII (external to internal) translation tables are listed in Table E-1.

The ASCII to EBCDIC (internal to external) translation tables are listed in Table E-2.

The internal hex (ANSI-standard ASCII) representations of Multinational characters are listed in Appendix G, Table G- 1.

Teradata RDBMS for UNIX SQL Reference

E-1
ASCII Hexadecimal Translation Tables

About This Appendix

Table E-1

EBCDIC to ASCII Translation

EB CHAR AS EB CHAR AS EB CHAR AS EB CHAR AS
00 NUL 00 40 SP 20 80 80 C0 { 7B
01 SOH 01 41 81 81 a 61 C1 A 41
02 STX 02 42 82 82 b 62 C2 B 42
03 ETX 03 43 83 83 c 63 C3 C 43
04 A8 44 84 84 d 64 C4 D 44
05 HT 09 45 85 85 e 65 C5 E 45
06 A9 46 86 86 f 66 C6 F 46
07 DEL 7F 47 87 87 g 67 C7 G 47
08 D1 48 88 88 h 68 C8 H 48
09 D2 49 89 89 i 69 C9 I 49
0A D3 4A ? 8B 8A 8A CA CA
0B VT 0B 4B 2E 8B C0 CB CB
0C FF 0C 4C < 3C 8C 8C CC CC
0D CR 0D 4D ( 28 8D AD CD CD
0E SO 0E 4E + 2B 8E 8E CE CE
0F SI 0F 4F 8D 8F 8F CF CF
10 DLE 10 50 & 26 90 90 D0 } 7D
11 DC1 11 51 91 91 j 6A D1 J 4A
12 DC2 12 52 92 92 k 6B D2 K 4B
13 DC3 13 53 93 93 l 6C D3 L 4C
14 BS D4 54 94 94 m 6D D4 M 4D
15 CAN D5 55 95 95 n 6E D5 N 4E
16 EM 08 56 96 96 o 6F D6 O 4F
17 D6 57 97 97 p 70 D7 P 50
18 18 58 98 98 q 71 D8 Q 51
19 19 59 99 99 r 72 D9 R 52
1A D7 5A ! 21 9A 9A DA DA
1B FS D8 5B $ 24 9B D0 DB DB
1C GS 1C 5C * 2A 9C 9C DC DC
1D RS 1D 5D ) 29 9D BD DD DD
1E US 1E 5E 3B 9E 9E DE DE
1F 1F 5F 5E 9F 9F DF DF

E-2

Teradata RDBMS for UNIX SQL Reference
ASCII Hexadecimal Translation Tables

About This Appendix

Table E-1

EBCDIC to ASCII Translation (Continued)

EB CHAR AS EB CHAR AS EB CHAR AS EB CHAR AS
20 E5 60 - 2D A0 A0 E0 \ 5C
21 E6 61 / 2F A1 ~ 7E E1 E1
22 D9 62 9B A2 s 73 E2 S 53
23 E7 63 9D A3 t 74 E3 T 54
24 E8 64 A2 A4 u 75 E4 U 55
25 LF 0A 65 A3 A5 v 76 E5 V 56
26 ETB 17 66 A4 A6 w 77 E6 W 57
27 ESC 1B 67 A5 A7 x 78 E7 X 58
28 E9 68 A6 A8 y 79 E8 Y 59
29 F0 69 A7 A9 z 7A E9 Z 5A
2A F1 6A I 7C AA AA EA EA
2B F2 6B 2C AB AB EB EB
2C F3 6C % 25 AC AC EC EC
2D ENQ 05 6D 5F AD [ 5B ED ED
2E ACK 06 6E > 3E AE AE EE EE
2F BEL 07 6F ? 3F AF AF EF EF
30 F4 70 C1 B0 B0 F0 0 30
31 F5 71 C2 B1 B1 F1 1 31
32 SYN 16 72 C3 B2 B2 F2 2 32
33 F6 73 C4 B3 B3 F3 3 33
34 F7 74 C5 B4 B4 F4 4 34
35 C9 75 C6 B5 B5 F5 5 35
36 F8 76 C7 B6 B6 F6 6 36
37 EOT 04 77 C8 B7 B7 F7 7 37
38 F9 78 A1 B8 B8 F8 8 38
39 E2 79 60 B9 B9 F9 9 39
3A E3 7A 3A BA BA FA FA
3B E4 7B # 23 BB BB FB FB
3C DC4 14 7C @ 40 BC BC FC FC
3D NAK 15 7D 27 BD ] 5D FD FD
3E E0 7E = 3D BE BE FE FE
3F SUB 1A 7F 22 BF BF FF FF

Teradata RDBMS for UNIX SQL Reference

E-3
ASCII Hexadecimal Translation Tables

About This Appendix

Table E-2

ASCII to EBCDIC Translation

AS CHAR EB AS CHAR EB AS CHAR EB AS CHAR EB
00 NUL 00 40 @ 7C 80 80 C0 8B
01 SOH 01 41 A C1 81 41 C1 70
02 STX 02 42 B C2 82 42 C2 71
03 ETX 03 43 C C3 83 43 C3 72
04 EOT 37 44 D C4 84 44 C4 73
05 ENQ 2D 45 E C5 85 45 C5 74
06 ACK 2E 46 F C6 86 46 C6 75
07 BEL 2F 47 G C7 87 47 C7 76
08 BS 16 48 H C8 88 48 C8 77
09 HT 05 49 I C9 89 49 C9 35
0A LF 25 4A J D1 8A 8A CA CA
0B VT 0B 4B K D2 8B 4A CB CB
0C FF 0C 4C L D3 8C 8C CC CC
0D CR 0D 4D M D4 8D 4F CD CD
0E SO 0E 4E N D5 8E 8E CE CE
0F SI 0F 4F O D6 8F 8F CF CF
10 DLE 10 50 P D7 90 90 D0 9B
11 DC1 11 51 Q D8 91 51 D1 08
12 DC2 12 52 R D9 92 52 D2 09
13 DC3 13 53 S E2 93 53 D3 0A
Previous << 1 .. 203 204 205 206 207 208 < 209 > 210 211 212 213 214 215 .. 241 >> Next