RE: Updating result set in Java

["Clapham, Paul" <pclapham@xxxxxxxxxxxxx>]

I didn't know about this FOR UPDATE clause.  But then, the only SQL
documentation I have is what I got when I downloaded the MySQL product to my
PC, and it doesn't mention this as something you can put in a Select
statement.  I also don't see it in the help for Microsoft Access.  Is there
something online (or otherwise available) that describes SQL syntax as
implemented by AS/400?

PC2

-----Original Message-----
From: Richard Dettinger [mailto:cujo@us.ibm.com]
Sent: February 5, 2001 12:56
To: JAVA400-L@midrange.com
Subject: RE: Updating result set in Java



Sorry.... just came to me what the problem (probably) is... you are
required to specify "FOR UPDATE" on statements that are updatable.  This
tells the database that we are potentially going to escalate locks later.
Creating the statement as updatable only tells the JDBC driver that you
want access to update methods.

</snip>
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---