RE: Returning Record Sets from SQLRPGLE Web Services

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 :)