Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 23 Mar 2012 @ 20:28:03 GMT


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


Subj:   Re: Compress column with 2 values
 
From:   Diehl, Robert

James,

NULL values are automatically compressed if you have any compress statement. So you would just want

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

Thanks,

Robert Diehl
Travelocity Data Warehouse DBA



     
  <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: 28 Jun 2020