Re: Embedded SQL & commitment control

[Phil Groschwitz <sublime78ska@xxxxxxxxx>]

Bruce,

Ok, but the problem I run into there is getting the
highest key value.  If I use 'max(key)' I can't use
the for update clause and if I use 'order by key desc'
I can't use the for update clause.  

So I'm wondering - is the way I'm trying to do it
unorthodox?

Phil


> 
> Yeah, see the row must be selected for Update when
> not using the
> serializable on set transaction.
> 
> On the cursor you might try adding the "for update"
> clause to the select in
> the cursor declaration.
> 
> 
>
===========================================================
> R. Bruce Hoffman, Jr.
>  -- IBM Certified Specialist - AS/400 Administrator
>  -- IBM Certified Specialist - RPG IV Developer
> 
> "America is the land that fought for freedom and
> then
>   began passing laws to get rid of it."
> 
>      - Alfred E. Neuman
> 
> 
> 
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to
> RPG400-L@midrange.com.
> | To subscribe to this list send email to
> RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list
> owner/operator: david@midrange.com
> +---


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---