-173 UR IS SPECIFIED ON THE WITH CLAUSE BUT THE CURSOR IS NOT READ-ONLY

Explanation

The cursor is not a read-only cursor. WITH UR can be specified only if Db2 can determine that the cursor is read-only.

System action

Statement execution fails.

Programmer response

If the cursor is intended to be read-only but is ambiguous, add the FOR FETCH ONLY clause. If the cursor is updatable, change the isolation level specified on the WITH clause.

SQLSTATE

42801