Archives of the TeradataForum

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

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

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>>