× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: RE: Updating result set in Java
  • From: "Xu, Weining" <Weining.Xu@xxxxxxx>
  • Date: Wed, 7 Feb 2001 14:50:26 -0500

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


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.