Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Compress column with 2 values
 
From:   JAMES PARK

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016