SQL Reference
For a SELECT INTO, FETCH with a read-only cursor, fullselect used in an
INSERT, row fullselect in an UPDATE, or scalar fullselect (wherever used),
level UR allows:
- Any row that is read during the unit of work to be changed by other
application processes.
- Any row that was changed by another application process to be read even if
the change has not been committed by that application process.
For other operations, the rules of level CS apply.
A comparison of the four isolation levels can be found on Appendix H. Comparison of Isolation Levels.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]