RE: limiting the selection of a record to update in SQL

I heartily agree with you Joe, however it is not our choice, ours not to reason 
why, etc. etc.

-----Oorspronkelijk bericht-----
Van: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Namens Joe Pluta
Verzonden: maandag 5 maart 2007 15:35
Aan: 'RPG programming on the AS400 / iSeries'
Onderwerp: RE: limiting the selection of a record to update in SQL

From: Raby, Steve

We are trying to update a file where we have records where the only thing
that MAY be different are the values(in this case number of items picked)
and dates, so what we are trying to do is get SQL to read only one record
at a time and then update a flag so it is not read again, then do some
other processing before the next record is read. We cannot find out how to
limit SQL to only update one record at a time. Can anyone help?

Not to be argumentative, but this sounds like the perfect thing to do with
native I/O.  If you must do this in SQL, you can use embedded SQL to create
a cursor, fetch the record for update, and then update the current record.

Joe