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

14 DC4 3C 54 T E3 94 54 D4 14
15 NAK 3D 55 U E4 95 55 D5 15
16 SYN 32 56 V E5 96 56 D6 17
17 ETB 26 57 W E6 97 57 D7 1A
18 CAN 18 58 X E7 98 58 D8 1B
19 EM 19 59 Y E8 99 59 D9 22
1A SUB 3F 5A Z E9 9A 9A DA DA
1B ESC 27 5B [ AD 9B 62 DB DB
1C FS 1C 5C \ E0 9C 9C DC DC
1D GS 1D 5D ] BD 9D 63 DD DD
1E RS 1E 5E Ë 5F 9E 9E DE DE
1F US 1F 5F — 6D 9F 9F DF DF

E-4

Teradata RDBMS for UNIX SQL Reference
ASCII Hexadecimal Translation Tables

About This Appendix

Table E-2 (Continued)

ASCII to EBCDIC Translation

20 SP 40 60 79 A0 A0 E0 3E
21 ! 5A 61 a 81 A1 78 E1 E1
22 “ 7F 62 b 82 A2 64 E2 39
23 # 7B 63 c 83 A3 65 E3 3A
24 $ 5B 64 d 84 A4 66 E4 3B
25 % 6C 65 e 85 A5 67 E5 20
26 & 50 66 f 86 A6 68 E6 21
27 ‘ 7D 67 g 87 A7 69 E7 23
28 ( 4D 68 h 88 A8 04 E8 24
29 ) 5D 69 i 89 A9 06 E9 28
2A * 5C 6A j 91 AA AA EA EA
2B + 4E 6B k 92 AB AB EB EB
2C 6B 6C l 93 AC AC EC EC
2D - 60 6D m 94 AD 8D ED ED
2E 4B 6E n 95 AE AE EE EE
2F / 61 6F o 96 AF AF EF EF
30 0 F0 70 p 97 B0 B0 F0 29
31 1 F1 71 q 98 B1 B1 F1 2A
32 2 F2 72 r 99 B2 B2 F2 2B
33 3 F3 73 s A2 B3 B3 F3 2C
34 4 F4 74 t A3 B4 B4 F4 30
35 5 F5 75 u A4 B5 B5 F5 31
36 6 F6 76 v A5 B6 B6 F6 33
37 7 F7 77 w A6 B7 B7 F7 34
38 8 F8 78 x A7 B8 B8 F8 36
39 9 F9 79 y A8 B9 B9 F9 38
3A 7A 7A z A9 BA BA FA FA
3B 5E 7B { C0 BB BB FB FB
3C < 4C 7C I 6A BC BC FC FC
3D = 7E 7D } D0 BD 9D FD FD
3E > 6E 7E ~ A1 BE BE FE FE
3F ? 6F 7F DEL 07 BF BF FF FF

Teradata RDBMS for UNIX SQL Reference

E-5
ASCII Hexadecimal Translation Tables

About This Appendix

E-6

Teradata RDBMS for UNIX SQL Reference
Data Conversion

Appendix F

Data Conversion

Teradata RDBMS for UNIX SQL Reference
Data Conversion

Teradata RDBMS for UNIX SQL Reference
Data Conversion

Data Conversion

Data Conversion

The Teradata RDBMS converts data from client format to Teradata RDBMS format. The internal format of data as it is stored on the Teradata RDBMS and on the AT&T 3B-series, Bull HN Worldwide Information Systems, IBM, DEC VAX/VMS, PC, and UTS client computers is described in the following set of tables.

Teradata RDBMS for UNIX SQL Reference

F-1
Data Conversion

Teradata RDBMS Internal Format

Teradata RDBMS Internal Format

Data Type Format
BYTEINT 8-bit signed two’s complement binary number (1 byte)
SMALLINT 16-bit signed two’s complement binary number, least significant byte first (2 bytes)
INTEGER 32-bit signed two’s complement binary number, least significant byte first (4 bytes)
FLOAT 64-bit IEEE floating point number, low-order byte first, with 1 bit for the fraction’s sign, 11 bits for exponent, 52 bits for unsigned fraction
DECIMAL(x,y) 8-bit, 16-bit, 32-bit, or 64-bit signed two’s complement binary integer, scaled by 10 ** y (stored as follows: 1-2 digits in 1 byte, 3-4 digits in 2 bytes, 5-9 digits in 4 bytes, 10-18 digits in 8 bytes; least significant byte first)
CHAR(n) n bytes containing mixed single byte character/multibyte character characters.
VARCHAR(n) 16-bit integer (2 bytes, least significant byte first) containing actual count k, depending on the character set, followed by k bytes of mixed single byte character/multibyte character characters or k ASCII characters (total of k + 2 bytes) (actual length k, where 0 <= k <= n).
LONG VARCHAR Equivalent to VARCHAR(32000)
GRAPHIC(n) n multibyte character characters.
VARGRAPHIC(n) 16-bit integer (2 bytes, least significant byte first) containing actual count k, followed by k/2 double byte characters (total of k + 2 bytes) (actual length k, where 0 <= k <= n).
LONG VAR-GRAPHIC Equivalent to VARGRAPHIC (16000).
BYTE(n) n bytes of data
VARBYTE(n) 16-bit integer (2 bytes, least significant byte first) containing actual count k, followed by k bytes of data (total of k + 2 bytes) (actual length k, where 0 <= k <= n)
DATE 32-bit signed two’s complement binary number, low-order byte first, with value calculated as (year-1900)*10000 + month*100 + day (4 bytes)

F-2

Teradata RDBMS for UNIX SQL Reference
Data Conversion

AT&T 3B-Series Internal Format

AT&T 3B-Series Internal Format

Data Type Format
BYTEINT 8-bit signed two’s complement binary number (1 byte)
SMALLINT 16-bit signed two’s complement binary number, most significant byte first (2 bytes)
INTEGER 32-bit signed two’s complement binary number, most significant byte first (4 bytes)
FLOAT 64-bit (double precision) floating point number, most significant byte first, with 1 bit for fraction sign, 11 bits for unsigned exponent (stored as actual + hex 3FFH), 52 bits for unsigned fraction (with an extra preceding 1 bit implied) (8 bytes total)
DECIMAL(x,y) 8-bit, 16-bit, 32-bit, or 4-bit<=4) signed two’s complement binary, most significant byte first (1,2,4, or 8 bytes)
CHAR(n) If character set is EUC, n bytes containing mixed single byte character/multibyte character characters (ASCII, KATAKANA, and EUC). If character set is not EUC, n bytes of ASCII character
Previous << 1 .. 204 205 206 207 208 209 < 210 > 211 212 213 214 215 216 .. 241 >> Next