RE: Update a particular record in a sequential file

[<SRamanujan@xxxxxxxxxxxxxxxxxx>]

Ganesh,
The point is to update the file.  An array may be helpful for reads.
But for update, even if you work on arrays, you would have to write them
back to the file and that will involve the I/O anyway.  The suggestion
to chain the rrn will be apt in which case, you can avoid reading
through the file but you should know the RRN.  I am not certain why you
would not like to create a view/logical/opnqryf which will enable you to
use an access path. This might be more efficient for you.  
Thanks,
Sudha

Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax

-----Original Message-----
From: ganeshkumar.murugesan@xxxxxxxxx
[mailto:ganeshkumar.murugesan@xxxxxxxxx] 
Sent: Thursday, April 28, 2005 3:09 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Update a particular record in a sequential file


I thought someone would tell me to use Pre run time arrays. Is it
possible?

Thanks,
Ganesh

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of MWaite@xxxxxxxxxxxx
Sent: Thursday, April 28, 2005 1:19 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Update a particular record in a sequential file

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



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.