-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.
- An application program issues a CREATE TABLE statement and an ALTER TABLE statement that creates a new table space version in the same commit scope.
- An 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.
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