Hi,

I am working on DB2 Version 4.1 on OS/390 Operating System.

I have altered a table.

By mistake, I have given the type for a column as DECIMAL(11,2) instead of CHAR(1). It was ofcourse a Copy Paste mistake of previous columns.

I want to get this fixed immediately.

I am unable to alter the column as well as unable to drop the column.

Please help me...

You can mail me at pepsoft239@yahoo.com

Thanks a lot for the help
Praveen

I think the only option available is to drop and recreate the table ...

Even with the latest release V8 (not yet GA), you can change the column types only between comatible types (ie, CHAR cannot smallint can be modified to int, but not char) ...


Not sure if you have any Change Management tools ... For eg, BMC Change Manager allows you to change the column type (though I assume it will be doing the same thing behind the scenes)

Cheers
sathyaram

Yes, BMC will automatically create a worklist to unload the data, drop the table, recreate the table with the changed columns, reload the data (to the correct columns), and rebind any packages or plans affected by the drop.