In this post, you’ll learn about the error message -679 the object name cannot be created because a drop is pending on the object in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-679 the object name cannot be created because a drop is pending on the object
Reason for the Error
The application program has executed a DROP for the specified object, and then tried to re create an object with the same name`(and of the same type) before the DROP was completed.
Solution
The logic of the application program must be modified to issue a COMMIT (or the IMS/VS or CICS equivalent) between the DROP and CREATE statements.
