RE: SETLL in SQL ?

["Paul Raulerson" <paul@xxxxxxxxxxxxxx>]

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.