Archives of the TeradataForum
Message Posted: Fri, 23 Mar 2012 @ 19:56:55 GMT
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')
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|