Hi Patrick, That SQL is correct syntax if you are running DB2 UDB version 8.1 or earlier and the isolation level is set pessimistic.
If you are not running the said DB2 version and still seeing "FOR UPDATE OF" string, then we have a problem in DB2Dictionary. Catalina On 9/6/07, Patrick Linskey <[EMAIL PROTECTED]> wrote: > > Hi, > > I'm seeing SQL like so: > > SELECT t0.ID, t0.VERSN, t0.STRINGFIELD FROM SIMPLEPERSISTENTCLASS t0 > FOR UPDATE OF > > Is this valid DB2 SQL? I'm using a DB2 database that returns SQL08016 > from a call to getDatabaseProductVersion(). I'm guessing that the > checks for the FOR UPDATE clauses are getting tripped up somewhere. > Any suggestions about what it should be for this version of DB2? > > -Patrick > > -- > Patrick Linskey > 202 669 5907 >
