RE: Update a particular record in a sequential file

This is stupid, but you could create an unkeyed logical over the file,
read from it or the physical till you find the record you want, then
chain to the other by rrn and do the update.  If you use SQL it's either
going to create an index or go through the file sequentially. The O/S
chooses for you. An important thing to realize is that blocked
sequential reads to a file go very fast.  If there are fewer than a
million records in the file it's darned quick.   

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Shannon ODonnell
> Sent: Thursday, April 28, 2005 11:38 AM
> To: 'RPG programming on the AS400 / iSeries'
> Subject: RE: Update a particular record in a sequential file
>
> If it's a flat file, you could use the Unix-type API LSeek to
> find the record you want to update.  It's a relatively simple
> API to use.
>
> 
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Peter.Colpaert@xxxxxxxxxx
> Sent: Thursday, April 28, 2005 2:25 AM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: Update a particular record in a sequential file
>
> Ganesh,
>
> short answer: "no".
>
> long answer: "no, this is not possible without either
> creating a logical or using embedded SQL"
>
> very long answer: "you don't need to read the file until the
> end, you can stop reading once you've reached and updated the record".
>
> HTH,
>
> Peter Colpaert
> Application Developer
> Massive - Kontich, Belgium
> -----
> Yoda of Borg are we.  Futile is resistance, assimilated will you be.
> -----
>
>
>
>
> <ganeshkumar.murugesan@xxxxxxxxx>
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 28/04/2005 09:17
> Please respond to RPG programming on the AS400 / iSeries
>
> 
>         To:     <rpg400-l@xxxxxxxxxxxx>
>         cc:
>         Subject:        Update a particular record in a
> sequential file
>
>
>
> I have this situation where I need to update a particular
> record in a file (Arrival sequence with no keys) without
> reading it fully. That particular record can be anywhere in
> the file. Is it possible to do this through RPGLE without
> creating any logical file for the file and also without using
> SQLRPGLE.
>
> Thanks,
> Ganesh
>
>
>
> Confidentiality Notice
>
> The information contained in this electronic message and any
> attachments to this message are intended for the exclusive
> use of the addressee(s) and may contain confidential or
> privileged information. If you are not the intended
> recipient, please notify the sender at Wipro or
> Mailadmin@xxxxxxxxx immediately and destroy all copies of
> this message and any attachments.
>
> --
> 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 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 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.
>
>

*****************************
NOTICE:
All e-mail sent to or from this e-mail address will be received or otherwise 
recorded by
The Sharper Image corporate e-mail system and is subject to archival, 
monitoring,
and review by and/or disclosure to Sharper Image security and other management.
This message is intended only for the use of the addressee and may contain 
information
that is privileged and confidential.

The contents of this message may contain personal views which are not the views 
of The Sharper Image.
If you are not the intended recipient, dissemination of this communication is 
prohibited.
*****************************