-679 THE OBJECT name CANNOT BE CREATED BECAUSE A DROP IS PENDING ON THE OBJECT
Explanation
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.
If the object is an index, this error is returned if the index that is to be created uses the same index space name as the index that was dropped without a commit.
System action
The statement cannot be processed. The specified object was not created.
Programmer response
The logic of the application program must be modified to issue a COMMIT (or the IMS™ or CICS® equivalent) between the DROP and CREATE statements.
SQLSTATE
57006
