RE: Updating result set in Java

["Xu, Weining" <Weining.Xu@xxxxxxx>]

Title: RE: Updating result set in Java

I use IBM "DB2 UDB for AS/400 SQL Reference Version 4" book, which you can get from online AS/400 Information Center.

But if Richard didn't mention that, I wouldn't know that I need to use this clause.  The statement looks like this:
       
        SELECT * FROM mytable FOR UPDATE;
or      SELECT * FROM mytable FOR UPDATE OF mycolumn1, mycolumn2;

Wayne

-----Original Message-----
From: Clapham, Paul [mailto:pclapham@core-mark.com]
Sent: Wednesday, February 07, 2001 2:26 PM
To: JAVA400-L@midrange.com
Subject: RE: Updating result set in Java

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
+---