Archives of the TeradataForum

Message Posted: Fri, 23 Mar 2012 @ 19:56:55 GMT

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

TD 13 on Windows.

I am trying to set compression on one column that has only 2 values; NULL and N.

I know that if the column 'ABC' has only NULL value I can set COMPRESS as this,

     ABC CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS,

But what if the column has another value 'N' as below how do you set compression for this column?

     Column ABC
              61150
     N        38850

Can I set COMPRESS this way?

     ABC CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS ('  ','N')

Thanks,

James Park
Database Specialist II

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