In this post, you’ll learn about the error message -910 the sql statement cannot access an object on which a drop or alter is pending in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-910 the sql statement cannot access an object on which a drop or alter is pending
Reason for the Error
The application program has issued a DROP or ALTER against an object, and then attempted to access that object before the DROP or ALTER is completed.
Solution
In the case of ALTER, the logic of the application program must be modified so that a COMMIT (or the IMS/VS or CICS equivalent) is executed between the ALTER and the failing SQL statement. For DROP, the logic of the application program should be modified such that there is no attempt to access an object after the DROP has been executed.
