Re: Update primary filre

Easiest way I can think of is to NOT make the primary file update capable.
Rather, open a logical file (or a second copy of the primary file, using
an OVRDBF for the same file, with a different name), then make that logical
or second copy update capable, and chain to it, then update that file.

I hope you understand that I don't mean copy the file, just open the
original file (IP on the F-spec) a second time (IF U K on the
F-Spec).
Use the Prefix keyword on that logical or second copy.

Assuming your Prefix is "UPD", after the L1 is reached in the program, do
the following

chain updKey updFile ;
UPDField = (whatever you calculated the Field from the Primary file to be)
;
update UPDFileRecFmt ;


In a message dated 4/23/2009 11:09:42 P.M. Jerusalem Daylight Time,
bob@xxxxxxxxxxx writes:

We have an old, large program (that we don't want to rewrite) which
processes a primary file and a secondary file using L1 M1 processing.
Both files are currently input only, and externally defined. At L1
total time an answer is calculated that we want to write back into the
primary file. When we change the primary to update capable, the L1
answer gets written into the subsequent record. We have tried both
UPDATE and EXCEPT, and get the same result: data updates the wrong
(subsequent) record. What's the best (or the easiest way) to update the
correct primary file record? Thanks!