RE: SETLL in SQL ?

That's my fault...

My example... was simply a select of all records, then when page up occurs
you position the cursor back x number of records. The cursor is never
closed.


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
"The Secret's the Sauce! Enjoy our new Bob-B-Q Pulled Pork Knife & Fork
Sandwich!"


rpg400-l-bounces@xxxxxxxxxxxx wrote on 10/11/2007 12:59:40 PM:

From: Michael_Schutte@xxxxxxxxxxxx

What do you mean? the program I pulled it from has been in use since
1998.
Page Up/Page Down works properly even after end of cursor is reached.

The fetch relative is only executed when the page up is pressed... on a
page down, a regular fetch is executed without positioning.

If you initially created the cursor with a "position to" (in SQL terms, a
WHERE clause such as WHERE NAME >= "G"), and then immediately try to roll
back (to get the last page of names starting with "F") you cannot use the
RELATIVE technique.

If your cursor contains ALL the records in the file, then you can

certainly

roll through them, but typically the user wants to position to a starting
key value, which requires the WHERE clause above (which corresponds to a
SETLL in RPG). Once you've done that, there's no way to use that cursor

to

get previous records.

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.