RE: HIVAL in SQL?

You should be able to:

Select (max(FieldNameForKey) + 1) from TableName into :HostVariable

Gord Royle

-----Original Message-----
From: THarteau@felkerbrothers.com [mailto:THarteau@felkerbrothers.com]
Sent: Thursday, December 13, 2001 2:08 PM
To: RPG400-L@midrange.com
Subject: HIVAL in SQL?


Hi,
     In SQL, is there the equivalent of SETLL *HIVAL then READP. I need to
find the key of the last record in the file, add 1 to it, then use that as
the key for a new record.  I wanted to use SQL, because I have a different
logical for this file already in the program. I think my field names are
getting messed up because of the two logicals. I am using ASSET, a RPG
generator, so I can't use PREFIX.  Thanks

P.S. 44/20. Started on RPG II, Can use the cycle, but usually choose not
to.
<===================================================>

Terri Harteau
****************
"There's no point in being grown up if you can't be childish sometimes."
- Dr. Who
****************





_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


Cott - The Leader in Premium Retailer Brand Beverage Innovation.