Are we able to rename a column in db2 v8 aix4.3 or 5.2?

M_RAS · #1 (**permalink**) 08-06-04, 11:18

Hi all,
I am working with db2 v8 fixpac 5 aix 5.2

Thanks in advance for your help.

Brownie · #2 (**permalink**) 08-06-04, 11:32

As far as I know - that's impossible. The only thing you can do is change the length of CHAR/VARCHAR fields.

dsusendran · #3 (**permalink**) 08-06-04, 11:37

You gotta drop and recreate table with the new column name.

Newbie

M_RAS · #4 (**permalink**) 08-06-04, 11:44

Quote:

Originally Posted by Brownie

As far as I know - that's impossible. The only thing you can do is change the length of CHAR/VARCHAR fields.

Thank you All,

I tried to change the length of column from char(8) to char(9) I got error SQL0190N!!!!! , I know varchar is OK but char I could not.

please advise

dsusendran · #5 (**permalink**) 08-06-04, 13:22

I know you can do that in DB2 V8 for z/OS. I am not sure on DB2 for Windows, Unix and Linux.

Newbie

cgprakash · #6 (**permalink**) 08-07-04, 06:43

Yes. You are right. In LUW, only varchar length can be increased. Plse note, we can not decrease length.

Regards
Prakash

Internet Services

Web Development

Digital Marketing

Consumer Tech