RE: subfile page up & down using embedded SQL

["Dan Bale" <dbale@xxxxxxxxxxxxx>]

I plan on using BLOCK.  First things first, though.

Could you expound a bit on your problems with BOF & EOF?  Is it related to
using RELATIVE?  Or subsequent FETCHes?

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx / Wayne.James@xxxxxxxxxxxx
> Sent: Wednesday, October 13, 2004 12:31 PM
>
> I use block fetches when I do this kinda stuff.
>
> So it will perform MUCH better than single FETCH PRIOR in a loop.
>
> The RELATIVE is indeed in the order of the (opened) access path.
>
> I have had poor experiences with hitting BOF and EOF.  The FETCH
> that is suppose to "start over" did not.  I ended up working
> around the issue.  If I had the time, I would chase IBM with a
> stick over how it did not work.  *SIGH*
>
> But do not let my poor experience deter you from your attempt.  What you
> are attempting is WONDERFUL, once you get it working.
>
> L. Wayne James
> Senior Developer
> Agilysys, Inc.
> Enterprise Solutions Group
> Hospitality Solutions
> 11545 Wills Road
> Alpharetta, GA 30004
> Phone:  770-962-6425 x1252
> Email:  Wayne.James@xxxxxxxxxxxx