how to change column name in db2 1

[chizi]

Hello everyone,

Do you think it is possible to change a column name in DB2 via Contral centre or CLP?

I appreciate you for your solution and suggestion

 

[ARWinner]

it is NOT possible to change anything about a column except to increase the size of a VARHAR.

You have two alternatives:

1) create a view the way you want the table to look.
2) export the data, drop the table, recreate it, import the data

HTH

Andy

 

[chizi]

Andy,

Your words made it clear. I appreciate you very much for your reply.