Archives of the TeradataForum

Message Posted: Mon, 08 Dec 2003 @ 16:45:49 GMT

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

Forgot to add that the same will happen if the table is empty also or having NULLs.

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

 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:
del t1;

del t1;

 *** Delete completed. One row removed.
 *** 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>>