-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

-679 THE OBJECT name CANNOT BE CREATED BECAUSE A DROP IS PENDING ON THE OBJECT

Explanation

System action

Programmer response

SQLSTATE

-679 THE OBJECT `name` CANNOT BE CREATED BECAUSE A DROP IS PENDING ON THE OBJECT