Thanks to everyone for their responses.
The SQL statement will do the trick. And a very good article as well.
Thanks again. This is exactly the kind of solution I was searching for.

- Steve

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Tuesday, August 12, 2008 6:07 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Returning Record Sets from SQLRPGLE Web Services

Hi Charles,

select *
from (select *
from ( select *
from svcvhdp
order by svcnum
fetch first (:rowsPerPage * :pageNumber) rows only
) t1
order by svcnum desc
fetch first :PageNumber rows only
) t2
order by svcnum

That 2nd "fetch" should say "fetch first :rowsPerPage rows only".
Surely if you're on page 2, you still want more than 2 rows :)

This thread ...


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

This mailing list archive is Copyright 1997-2020 by 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].