logo  
Google
 

DB2 SQL-Error: -173

SQLState: 42801

Short Description: UR IS SPECIFIED ON THE WITH CLAUSE BUT THE CURSOR IS NOT READONLY

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 updateable, change the isolation level specified on the WITH clause.

 <-  BACK TO INDEX