-910   THE SQL STATEMENT CANNOT ACCESS AN OBJECT ON WHICH UNCOMMITTED CHANGES ARE PENDING

Explanation

The application program attempted to access an object that has been modified and the changes have not yet been committed. This error is issued in the following situations:
  • When an application program issues a data definitional statement (DROP, ALTER, CREATE, or RENAME) against an object, and then attempts to access that object before the operation is complete.
  • When the application program issues an ALTER or CREATE statement, and a data manipulative statement (such as INSERT, UPDATE, DELETE, MERGE, or SELECT) is processed for the same object, in the same commit scope.

System action

The statement cannot be processed.

Programmer response

Modify the logic of the application program, other than the logic for DROP, so that a COMMIT (or the IMS™ or CICS® equivalent) is executed between the data definitional statement and the failing SQL statement, or between the data manipulative statement and the data definitional statement. In cases where open held cursors are associated with the failing SQL statement, the cursor must be closed prior to COMMIT.

For DROP, the logic of the application program should be modified so that no attempt is made to access an object after the DROP has been executed. Attention: DROP includes cases when rollback to a savepoint includes rolling back to a CREATE.

SQLSTATE

57007