Hi,

I have a table in DB2 v8 in which a column is of INTEGER Type. It have some data as well, I want to convert it to varchar(20). I am using AQT tool, when I trying to alter it Combo box is coming as disabled.

When I try from Command Window, get following error:

Make the attributes specified compatible with the existing column,
remove the attribute specification, or specify a different column name.

I heard that we can't alter structure in DB2 v8, is it so?

Is there any command using which we can find the DB2 version?

Thanks,

That feature is not available in DB2 V8 LUW. You can find the DB2 release with the "db2level" command issued from a command line session. Believe it or not, IBM actually publishes DB2 manuals and they are available in PDF format to be downloaded for free. You will want the SQL Reference Vol 2 manual for release 8.2 (I am assuming you have 8.2, which is the same as 8.1 FP 7 or later).

When I connected to database using command line I got following output:

Database server = DB2/SUN64 9.5.5
SQL authorization ID = XXXXXX
Local database alias = XXXXXX

This means we have 8 version installed...if it is so, how to alter table in this version?

yes DB2/SUN64 9.5.5 means v8 is installed
I mean.. it clearly indicates V9 ?????
db2level has to be executed on server to see server level
it would be a good idea to read some about db2
IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

It only says
Database server = DB2/SUN64 9.5.5 .

Means there is no method to change the datatype

(Deleted. Because of my misunderstanding)