Archives of the TeradataForum

Message Posted: Tue, 08 Jul 2003 @ 17:44:15 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Try v2r5 manual SQL Volume 3 Chapter 7....

You CANNOT compress the following data types:

* INTERVAL
* TIME
* TIMESTAMP
* VARBYTE
* VARCHAR

NULL can be specified alone, but it must be enclosed in parentheses - same as COMPRESS without an argument.

To compress specific values, the following will work:

CREATE SET TABLE cmpr_timstp
      (
      Pkey1 integer,
      atimestamp   timestamp(1) compress
      adate        date compress (date '2003-07-08',date '9999-12-31')
      abyteint     byteint compress (0,1,2,3,4,5,6)
       )
UNIQUE PRIMARY INDEX ( pkey1 );

Kyle Prescott
Teradata Certified Professional
UnumProvident - Data Strategies, 3-South

	<Prev	Next>		<<First	<Prev	Next>	Last>>