RE: SETLL in SQL ?

Look into using the FETCH relative.


When you go backwards...

C Eval Idx=(-1*Arrn)-11
* Set cursor back 10 records
C/EXEC SQL
C+ FETCH RELATIVE :Idx FROM C1
C/END-EXEC


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:29:11 PM:

From: David Foxwell

I'm looking at a progrram that does charges a subfile with SETLL

followed

by READE on ROLLUP, SETGT followed by READPE on ROLLDOWN.

What would be the equivalent in SQL if I wanted to replace the

SETLL/GT?

Close cursor?

Yup. In order to reposition a file for reading by key, you need to
re-create the cursor. This is one of the fundamental features of ISAM

that

SQL lacks. There is no way to position by key within a result set or a
cursor.

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.