Hi , i have some problem with DB2 ..the problem is when i INSERT INTO X table huge amount of data from Y table and after that i drop the Y table... theY table cannot be dropped and the errror message
"SQL0950N The table or index cannot be dropped because it is currently in use.
Explanation: A DROP TABLE or DROP INDEX statement cannot be issued when an open cursor is currently using the table or index. "
it says that table Y is still in use .... the cursor is still in table Y ... i tried a lot of method but still cannot solve it... the cursor is still in the Y table but this problem doesnt happen in Oracle...
hope that someone can help ... thanks in advance