Can any one help me regarding the deleting the column while having values in that column In DB2.

Could you be more specific? What do you want to achieve?

If you are using DB2 LUW V9.7, you can use the ALTER TABLE DROP COLUMN command.
If you are using a version of DB2 that does not have this command, you will need to save the data (export / unload) without the column you want to remove, drop the table, create the table without the column, and then put the data back into the table (load / insert).

actually, without being able to spell the name of the database you are working on you should not attempt any of this.

Create the new table having structure you need, and

Insert INTO new_tbl
select <remein colums> from old_tbl;

Lenny

Or (best way) create view from your tables, shown only columns needed to you.

Lenny