Hi Greetings..

We are using DB2 8.2 on Windows 2000 Server.

I would like to know In DB2, Is it possible for us to drop a column from a populated table?

regards

Rajeev

No,
Its not possible.
what you can do is.
1> Export the records to a .csv file.
2> Take out the DDL of the table
3>Drop the table
4>Make the required change in the DDL (remove the column)
5>Open the .csv file in a excel sheet and remove the records for the particular column.
6> Create the new table with the modified DDl
7> Import the new .csv file to the table.

Tx,
Jay

Thank you very much Jay for your immediate response.

regards

Rajeev

Using ALTOBJ stored proc is an alternative

Jay step is correct, however I am lazy bum and like to skip steps. So, in situation like that I export to ixf only the columns that will need to be in the new table. Then import. It removes the manual work, thus limits on errors.