Re: Update a particular record in a sequential file

[Alan C <steelville@xxxxxxxxxxx>]

You can also "simulate" an "unkeyed logical over the file" by defining a 
full-procedural file in the F-specs with a name different from the 
physical file, but override the name to the physical file both at 
compile and then run time.

F filename      I F E   DISK
F filename1    I F E    DISK rename ( pfrecord : pfrecord1 )
                                           usropn

Then call QCMDEXC to override it, or if you're on V5R3 or maybe V5R2  I 
think you can define the override on the F-specs keywords. (Right?)

Then open it and off you go.

- Alan


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