Re: D-spec using the same file name twice

[Rory Hewitt <roryhewitt@xxxxxxxxx>]

Alan,

What would be the problem with simply reading the 5400247 record, saving its
details, deleting it, reading the 1 record and updating it with the details
from the 5400247 record? Simply define the file as update-capable in the
F-specs.

Seems a lot simpler to me and you wouldn't need all this duplicate-file
stuff.

Rory

On Tue, Nov 17, 2009 at 12:58 PM, Alan Shore <AlanShore@xxxxxxxx> wrote:

> Thanks for your reply Booth
> Maybe the choice of the word key was the wrong choice
> Here is my example
> the key to the customer file is by customer number
> 2 records exist the customer file
> customer number 1
> customer number 5,400,247
> They are in fact the same person, so we need to "merge" the data from
> customer number  5,400,247 into customer number 1
> Update customer number 1
> delete customer number  5,400,247
>
> I think it would be easier (maintenance wise) to have 2 separate files,
> both keyed by customer number. One file is to update. The other file is to
> delete
> Is this fool proof - no, but in the long run, it will be simpler (my
> opinion for what its worth)
>
>
>
> Alan Shore
> Programmer/Analyst, Distribution
> E:AShore@xxxxxxxxxxx <E%3AAShore@xxxxxxxxxxx>
> P:(631) 200-5019
> C:(631) 880-8640
> "If you're going through Hell, keep going" - Winston Churchill