RE: subfile page up & down using embedded SQL

I did the "track where I am (supposed to be)" thing that Charles 
suggested.

As Karen mentioned, you should be able to FETCH BEFORE/FETCH AFTER.  But I 
received an error that seemed to indicate I had done a FETCH RELATIVE of 
too many records when I tried to use them.  So I ended up doing a FETCH 
FIRST/PRIOR and FETCH LAST/NEXT to properly position the cursor and get an 
appropriate SQLCOD for the operation.

I would argue that such behavior is not consistent with the documentation.

Hope your experience is more pleasant.  Please do not let this little 
"bump in the road" stop you from using such a great technique.

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



"Dan Bale" <dbale@xxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
10/13/2004 01:00 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: subfile page up & down using embedded SQL






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

--
This is the RPG programming on the AS400 / 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.