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

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 /multibyte characters (ASCII, KATAKANA, and EUC multibyte character) or k ASCII characters (total of k + 2 bytes) (actual length k, whereO <= k <= n).
LONG VARCHAR Equivalent to VARCHAR(32000)
BYTE(n) n bytes
VARBYTE(n) 16-bit integer (2 bytes) containing actual count k, followed by k bytes (total of k + 2 bytes)(actual length k, where 0 <= k <= n)
DATE 32-bit signed two’s complement binary number, most significant byte first, with value calculated as (year-1900)*10000 + month*100 + day (4 bytes)
GRAPHIC(n) n EUC multibyte character characters.

Teradata RDBMS for UNIX SQL Reference

F-3
Data Conversion

AT&T 3B-Series Internal Format

Data Type Format
VARGRAPHIC(n) 16-bit integer (2 bytes, least significant byte first) containing actual count k, followed by k/2 EUC multibyte character characters (total of k + 2 bytes) (actual length k, where 0<=k<=n)
LONG VAR GRAPHIC Equivalent to VARGRAPHIC (16000).

F-4

Teradata RDBMS for UNIX SQL Reference
Data Conversion

Bull HN Internal Format

Bull HN 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 exponent’s sign, 7 bits for two’s complement exponent, 1 bit for fraction’s sign, and 55 bits for two’s complement fraction (8 bytes total)
DECIMAL(x,y) x-digit, signed, packed decimal, where the rightmost nibble represents the sign (+ being hex A,B,E,F, or preferably C; - being hex D) and the remaining nibbles represent the digits (hex 0-9) left-padded with zero digits (total (x+2)/2 bytes, 8 bytes maximum)
CHAR(n) n ASCII characters (n bytes)
VARCHAR(n) 16-bit integer (2 bytes) containing actual count k, followed by k ASCII characters (total of k + 2 bytes) (actual length k, where 0 <= k <= n)
LONG VARCHAR Equivalent to VARCHAR(32000)
BYTE(n) n bytes
VARBYTE(n) 16-bit integer (2 bytes) containing actual count k, followed by k bytes (total of k + 2 bytes) (actual length k, where 0 <= k <= n)
DATE 32-bit signed two’s complement binary number, most significant byte first, with value calculated as (year-1900)*10000 + month*100 + day (4 bytes)

Teradata RDBMS for UNIX SQL Reference

F-5
Data Conversion

IBM Mainframe Internal Format

IBM Mainframe 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’s sign, 7 bits for unsigned excess-64 exponent, and 56 bits for unsigned fraction (8 bytes total)
DECIMAL(x,y) x-digit, signed, packed decimal, where the rightmost nibble represents the sign (+ being hex A,E,F, or preferably C; - being hex B or preferably D) and the remaining nibbles represent the digits (hex 0-9) left-padded with zero digits if x is even (total (x+2)/2 bytes; 8 bytes maximum)
CHAR(n) If character set is EBCDIC, n bytes containing mixed single byte character/multibyte character characters. Otherwise, based on the CCSID of the character set, contains mixed single byte character/multibyte character characters (EBCDIC, KATAKANA, and EUC).
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 /multibyte characters (EBCDIC, KATAKANA, and EBCDIC multibyte character) or k EBCDIC characters (total of k + 2 bytes) (actual length k, where 0 <= k <= n).
LONG VARCHAR Equivalent to VARCHAR(32000)
BYTE(n) n bytes
VARBYTE(n) 16-bit integer (2 bytes) containing actual count k, followed by k bytes (total of k + 2 bytes) (actual length k, where 0 <= k <= n)

F-6

Teradata RDBMS for UNIX SQL Reference
Data Conversion

IBM Mainframe Internal Format

Data Type Format
DATE 32-bit signed two’s complement binary number, most significant byte first, with value calculated as (year-1900)*10000 + month*100 + day (4 bytes)
GRAPHIC(n) n kanji EBCDIC double byte character characters.
VARGRAPHIC(n) 16-bit integer (2 bytes, least significant byte first) containing actual count k, followed by k/2 kanji EBCDIC double byte characters (total of k + 2 bytes) (actual length k, where 0 <= k <= n).
LONG VAR GRAPHIC Equivalent to VARGRAPHIC (16000).

Teradata RDBMS for UNIX SQL Reference

F-7
Data Conversion

UTS Internal Format

UTS Internal Format

Data Type Format
BYTEINT 8-bit signed two’s complement binary number (1 byte)
Previous << 1 .. 205 206 207 208 209 210 < 211 > 212 213 214 215 216 217 .. 241 >> Next