RE: SETLL in SQL ?

You didn't hear what I asked Joe; I asked about scrollable cursors, which
*do* allow you to

move around by relative position in a cursor. As in this kind of stuff. Note
the fetch

statement.



...initialize program summation

salary variable

EXEC SQL

FETCH RELATIVE 3 FROM THISEMP

INTO :EMP-NUM, :NAME2,

:JOB-CODE

END-EXEC.

...add the current salary to

program summation salary

...branch back to fetch and

process the next row.



http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/sqlp/
rbafycursorexamp.htm

-----Original Message-----

From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-

bounces@xxxxxxxxxxxx] On Behalf Of Joe Pluta

Sent: Thursday, October 11, 2007 9:01 PM

To: 'RPG programming on the AS400 / iSeries'

Subject: RE: SETLL in SQL ?

From: Paul Raulerson

Not to be argumentive either, but are you saying that DB/2 on a 400

doesn't support

scrollable cursors? I would be rather surprised to find that is true.

And scrollable cursors allow you to position either by sequence or by

reference.

You cannot position a cursor by key. This is true in all dialects of

SQL.

Specifically: Create a table with an alpha field. Create a cursor over

all

records in the table ordered by the alpha field. Position that cursor

to

the first record where the field is equal to or greater than "G".

This is what a SETLL does. There is no equivalent in SQL.

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.