FOR FETCH ONLY WITH UR is IBM DB2-code for fetching uncommited changes from other sessions. FOR FETCH ONLY - means the cursor is read only, issues different types of locks and does not allow for update. WITH UR - means instead of retrieving only committed work, your SELECT or FETCH will also retrieve rows that have not been committed by other tasks. This sort of "Dirty reads" is not allowed in Oracle.
... View more