I am not sure if you can delete a column unless it has come in in recent versions of DB2. The normal way is to drop the table and recreate it with the new definition.
The problem I have is that people can explain things quickly but I can only comprehend slowly. Regards Nic
1) unload the data from the current table but ignore the data in the column that you do not want 2) drop the table 3) recreat the table with the new definition 4) load the table from the saved data
The problem I have is that people can explain things quickly but I can only comprehend slowly. Regards Nic
ok,good idea only, but in sql server and oracle we can delete the column direcly, need of above septs, why it is not in db2. thats why i asked.if we have more data it is difficcult one..