RE: SETLL in SQL ?

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