-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:
  • An application program issues a DROP, ALTER, CREATE, or RENAME statement against an object, and then attempts to access that object before the operation is complete.
  • An application program issues an ALTER or CREATE statement, and an INSERT, UPDATE, DELETE, MERGE, or SELECT statement is processed for the same object in the same commit scope.
  • Start of changeAn application program issues a CREATE TABLE statement and an ALTER TABLE statement that creates a new table space version in the same commit scope.End of change
  • Start of changeAn application program issues a DROP, ALTER, CREATE, or RENAME statement against an object, and then attempts to access that object using an INSERT, UPDATE, DELETE, MERGE, or SELECT statement before the DROP, ALTER, CREATE, or RENAME statement completes.End of change

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 definition statement and the failing SQL statement, or between the data manipulative statement and the data definition 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