Alter Column Length

ADee · #1 (**permalink**) 06-25-04, 06:55

I m on DB2 7.1 ,OS win2000;
using control center i can alter the table colum lenght having VARCHAR type,but its not allow me to do the same with CHARACTER type.
anyone know how to do it???
tell me query as well if u know
plz

J Petruk · #2 (**permalink**) 06-25-04, 07:15

Quote:

Originally Posted by ADee

I m on DB2 7.1 ,OS win2000;
using control center i can alter the table colum lenght having VARCHAR type,but its not allow me to do the same with CHARACTER type.
anyone know how to do it???
tell me query as well if u know
plz

You can't change the length of a CHAR column. To do it you need to drop/recreate the table.

ADee · #3 (**permalink**) 06-25-04, 07:21

hummmm.....so suppose to do a long job...anyways Thanx alot!

Internet Services

Web Development

Digital Marketing

Consumer Tech