RE: SETLL in SQL ?

Joe;

I didn't quite understand before, and you are correct, after a position to
the user can't page up.

I think you could do a "binary" search of the cursor using fetch relative to
get around closing and re-opening a cursor to do a position to. I will have
to try this sometime.

Duane Christen

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Joe Pluta
Sent: Thursday, October 11, 2007 11:57 AM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: SETLL in SQL ?

From: Christen, Duane J.

Actually there is a way,

The code here does a subfile completly with sql cursors.

http://code.midrange.com/57ec2af462.html

Not to be argumentative, but there isn't a way without
closing the cursor.
If you do a position to, and then try to get the previous
page, you have to
close the cursor, open a reverse direction cursor using the
current keys,
read N records, then close THAT cursor, open a forward cursor
using the new
keys and read forward.

I assume that's what your "rollup" subroutine does.

There is no way to position a cursor by key.

Joe

--
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.


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

NOTICE: This electronic mail transmission may contain confidential
information and is intended only for the person(s) named. Any use, copying
or disclosure by any other person is strictly prohibited. If you have
received this transmission in error, please notify the sender via e-mail.