Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 08 Dec 2003 @ 16:34:05 GMT


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


Subj:   Re: alter table compression
 
From:   Vivek Pandey

Victor,

Based on this I did some experiments & here is what I get.

 BTEQ -- Enter your DBC/SQL request or BTEQ command:
show table t1;

show table t1;

 *** Text of DDL statement returned.
 *** Total elapsed time was 1 second.

-----------------------------------------------------------------
CREATE SET TABLE DR_DWH_LM_GH.t1 ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL
     (
      a INTEGER,
      b INTEGER,
      c VARCHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC FORMAT 'X(5)')
PRIMARY INDEX ( a );


 BTEQ -- Enter your DBC/SQL request or BTEQ command:
sel * from t1;

sel * from t1;

 *** Query completed. One row found. 3 columns returned.
 *** Total elapsed time was 1 second.

          a            b  c
-----------  -----------  -----
          1            2  xxx

 BTEQ -- Enter your DBC/SQL request or BTEQ command:
alter table t1 add b compress 0;

alter table t1 add b compress 0;
 *** Failure 3558 Cannot alter the specified attribute(s) for B.
                Statement# 1, Info =0
 *** Total elapsed time was 1 second.


 BTEQ -- Enter your DBC/SQL request or BTEQ command:
alter table t1 add c compress 'a';

alter table t1 add c compress 'a';
 *** Failure 3558 Cannot alter the specified attribute(s) for C.
                Statement# 1, Info =0
 *** Total elapsed time was 1 second.


 BTEQ -- Enter your DBC/SQL request or BTEQ command:

Thanks, Vivek.



     
  <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: 23 Jun 2019