RE: sql question

["Mike Collins (syan)" <mike.collins@xxxxxxxxxx>]

On the FETCH statement there is a scroll option. There is a default of NEXT
which means it just reads the next row, but you can also specify RELATIVE
followed by a number. So if for instance you had a subfile of ten records, you
would build the page by using ten FETCH operations with NEXT. Then to rebuild
the previous page use FETCH RELATIVE -20 before your FETCH loop. I don't have
an example for you, but this should work.
+---
| 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
+---