Version IBM DB2 Personal Edition 7.?? and IBM DB2 Server Edition 7.??

Got all the patch.

Command -
ALTER TABLE table_name ALTER COLUMN "column_name" SET DATA TYPE DECIMAL(9,3)

and

ALTER TABLE table_name ALTER COLUMN "column_name" DECIMAL(9,3)

error -
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor. During SQL processing it returned: found following "BEGIN-OF-STATEMENT". Expected tokens may include: "<values>". SQLSTATE=42601

I'm trying to alter a column from a Decimal (5,0) to a Decimal(9,3) there are value in the column.

Hi

I don't think you can alter columns like that,
and especially not i version 7.

I think you will hav to move data to a new table
with the requuired columns, drop the old table and
rename the new.

Some say that the new DB2 version - Stinger will make
this possible

HTH

You can add a column, but you can only alter the length of a varchar on DB2 for Linux, UNIX, and Windows.

Thank You all for your advice.

in db2 , you cann't change the most column property , only can change the varchar length .etc .