RE: SETLL in SQL ?

["Christen, Duane J." <dchristen@xxxxxxxxxxxxx>]

Actually there is a way,

The code here does a subfile completly with sql cursors.

http://code.midrange.com/57ec2af462.html

Duane Christen

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Joe Pluta
> Sent: Thursday, October 11, 2007 11:29 AM
> To: 'RPG programming on the AS400 / iSeries'
> Subject: RE: SETLL in SQL ?
>
>
> > 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.
>
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email 
> ______________________________________________________________________



NOTICE: This electronic mail transmission may contain confidential
information and is intended only for the person(s) named.  Any use, copying
or disclosure by any other person is strictly prohibited. If you have
received this transmission in error, please notify the sender via e-mail.