Re: Embedded SQL & commitment control

Ooops. yeah, grouped.

Order it descending and get the first.

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

-----Original Message-----
From: Phil Groschwitz <sublime78ska@yahoo.com>
To: RPG400-L@midrange.com <RPG400-L@midrange.com>
Date: Wednesday, March 14, 2001 5:43 PM
Subject: Re: Embedded SQL & commitment control


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

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