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


OPTIMIZE

PACKAGE

The following are reserved words in DB2 (Version 4), and not in Teradata SQL:

AUDIT

BUFFERPOOL

CALL

CAPTURE

COLLECTION

CONCAT

CURRENT_DATE (to be supported by Teradata SQL in V2R3)

CURRENT_TIME (to be supported by Teradata SQL in V2R3)

CURRENT_TIMESTAMP (to be supported by Teradata SQL in V2R3)

DAYS

EDITPROC

END-EXEC

ERASE

FIELDPROC

HOURS

Teradata RDBMS for UNIX SQL Reference

C-23
Comparing Teradata SQL and DB2

Reserved Words Comparison

INOUT

LOCKMAX

LOCKSIZE

MICROSECOND

MICROSECONDS

MINUTES

MONTHS

NUMPARTS

OBID

OPTIMIZE

OUT

PACKAGE

PART

PLAN

PRIQTY

PROGRAM

SECONDS

SECQTY

STOGROUP

SUBPAGES

SYNONYM

TABLESPACE

VALIDPROC

VCAT

VOLUMES

YEARS

Reserved words in Teradata SQL and not in DB2 are listed in the following table:

C-24

Teradata RDBMS for UNIX SQL Reference
Table C-2

Teradata SQL Reserved Words (not in DB2) (1 of 2)

Comparing Teradata SQL and DB2

Reserved Words Comparison

ABORT DATABLOCKSIZE JOURNAL
ABORTSESSION DA
ABS DAY LAST
ACCOUNT DEC LE
ADD_MONTHS DECIMAL LN
AFTER DEL LOADING
ALIAS DESC LOCAL
ASC DIAGNOSTIC LOCK
ASCII DUMP LOCKING
AUTHORIZATION LOG
AVE EACH LOGGING
AVERAGE EBCDIC LOGON
AVG ECHO LONG
ELSE LT
BEFORE END
BEGIN EQ MACRO
BOTH ERRORFILES MAX
BT ERRORTABLES MAXIMUM
BUT ET MCHARACTER
BYTE EXCL MIN
BYTEINT EXCLUSIVE MINIMUM
BYTES EXEC MINUS
EXP MLOAD
CASE EXPLAIN MOD
CASESPECIFIC EXTRACT MODE
CAST MODIFY
CD FALLBACK MONRESOURCE
CHAR FASTEXPORT MONSESSION
CHAR2HEXINT FLOAT MSUBSTR
CHARS FORMAT
CHARACTERS NAMED
CHECKPOINT GE NE
CM GIVE NHEADER
COALESCE GRAPHIC NO
COLLATION GT NULLIFZERO
COLLECT NUMERIC
COMMENT HASHAMP
COMMIT HASHBAKAMP OCTET_LENGTH
COMPRESS HASHBUCKET OVERRIDE
CREATE HASHROW
CROSS HELP
CS
CT INDICATOR
CURRENT INS
CV INT

INTEGER

INTERSECT

Teradata RDBMS for UNIX SQL Reference C-25
Comparing Teradata SQL and DB2

Reserved Words Comparison

Teradata SQL Reserved Words (not in DB2) (2 of 2)

PASSWORD SEL UC
PCTFREE SESSION UNIQUE
PCTINDEX SHARE UPD
PERCENT SHOW UPPERCASE
PERM SMALLINT
PERMANENT SOME VARBYTE
PRECISION SPOOL VARCHAR
PRIMARY SQRT VARGRAPHIC
PRIVATE STARTUP
PROTECTION STATISTICS WAIT
PUBLIC SUBSTR WORK
READ SUM WRITE
REAL TEMPORARY ZEROIFNULL
RELEASE TIME
RENAME TITLE
REPLACE TRANSACTION
RESTART TRIM
RESTORE TYPE

RET

RETRIEVE

REVOKE

RIGHTS

ROLLBACK

ROLLFORWARD

ROW

RUN

C-26

Teradata RDBMS for UNIX SQL Reference
Comparing Teradata SQL and DB2

Limitations: DB2 Vs. Teradata SQL

Limitations: DB2 Vs. Teradata SQL

The differences in limitations between Teradata SQL and DB2 are listed in Table C-3, Table C-4, Table C-5, and Table C-6.

Table C-3 Limitations, Teradata SQL and DB2

Specification DB2 V3 DB2 V4 Teradata SQL V2R2.0
Maximum Number of Databases 65,279 65,279 32,000
Largest SQL Statement/Request Allowed 32,765 bytes 32,765 bytes 32,768 bytes
Maximum Number of Columns/Table or View 750 or less 750 or less a 6 5 2
Maximum Row Size Without EDITPROC: 4K Pg: 4046 32K Pg: 32704 Without EDITPROC: 4K Pg: 4056 32K Pg: 32714 32,216 bytes
Maximum Number of Columns in Index Key 64 64 32b
Maximum Characters in String Constant 254 bytes 254 bytes 255c bytes
Column Name Size 18 bytes alias, table, columns, view names 18 bytes alias, table, columns, view names 30 bytes (30 character)
Largest table (or tablespace in DB2) 64 gigabytes 64 gigabytes Several terabytesd

a. A total of 512 columns can be defined during the life of the table.

b. Up to 32 secondary indexes can be defined for one table. these can be unique or non-unique.

c. Longer constants can be built using the || operator.

d. There is no limit on the table size. Size is limited by the size of the system installed and by the maximum storage Teradata RDBMS can support, which is currently about 20 Terabyte. Also table size is influenced by row size, and larger rows would require less overall overhead and hence enable slightly larger tables.

Teradata RDBMS for UNIX SQL Reference

C-27
Comparing Teradata SQL and DB2

Limitations: DB2 Vs. Teradata SQL

Table C-4 Numeric Limits: Teradata SQL Vs. DB2

Specification DB2 V3 DB2 V2R3.0 Teradata SQL V2R2.0
Smallest INTEGER value -2,147,483,648 -2,147,483,648 -2,147,483,648
Largest INTEGER value 2,147,483,647 2,147,483,647 2,147,483,647
Smallest SMALLINT value -32,768 -32,768 -32,768
Largest SMALLINT value 32,767 32,767 32,767
Largest decimal precision 31 31 1 to 18
Smallest FLOAT value About -7.2x1075 About -7.2x1075 2.2 2 6x10-308
Largest FLOAT value About 7.2x1075 About 7.2x1075 1.797x10308
Smallest Positive Float About 5.4x10-79 About 5.4x10-79 7 0 -3 -0 1 x 2
Largest Negative Float About -5.4x10-79 About -5.4x10-79 2 x 0 + OO O OO
Previous << 1 .. 201 202 203 204 205 206 < 207 > 208 209 210 211 212 213 .. 241 >> Next