Re: Update a particular record in a sequential file

[MWaite@xxxxxxxxxxxx]

Just a thought.  Do have the relative record number of the record you 
require?  Or could you arrange to store it from a previous process?  If 
you known the RRN you can CHAIN straight to the record required without 
using any indexes.  I have to say you don't do this kind of thing very 
often though - you'd need quite a good reason not to create a logical 
file...


Mike

rpg400-l-bounces@xxxxxxxxxxxx wrote on 28/04/2005 08:24:43:

> 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.
> 
>