Until now I either use 2 cursors or I do some paging and fill my screen size
or Subfile Page with this information as follows:
With x as (Select .... From File
Where ...
Order By Key1, Key2, ...
Fetch first :TotNbrRows rows Only)
Y as (Select * From x
Order By Key1 Desc, Key2 Desc, ...
Fetch first :NbrRowsPage rows Only)
Select *
From Y
Order By Key1, Key2, ...);
If you replace :TotNbrRows with 200 and NbrRowsPage with 20 then you?ll read
the 180 to 200th row.
Beginning with the last technology refresh, we?ll get LIMIT and OFFSET.
Select ?
From ?
Where ?
Order By
Limit 20 OffSet 100;
The example above starts with the 100th row and reads the next 20 rows of
the specified query.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im Auftrag von Booth
Martin
Gesendet: Friday, 13.11 2015 09:57
An: RPG programming on the IBM i / System i
Betreff: embedded SQL fetch relative -29 ...
Using SQL, I can page ahead in a page-at-a-time subfile easily but when it
comes time to page down, I believe the best way is for me to use fetch
retrieve - (2 pages +1). The few examples I have been able to find seem
correct and to the point, but I can not make them work. I am missing
something.
Can someone point to a good example somewhere that I can look at?
--
Booth Martin
www.martinvt.com
(802)461-5349
Brady's First Law of Problem Solving: When confronted by a difficult
problem, you can solve it more easily by reducing it to the question, "How
would the Lone Ranger have handled this?"
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
