RE: copy records from one file to another

[Jim Langston <jlangston@xxxxxxxxxxx>]

Easiest way: Don't use prefix.  Then both files will have the same field names, 
correct?  Read from FileA and FileB's field will have the same contents.

C           DoW   NOT %Eof(FileA)
C           Read  FileA
C           Write FileB
C           EndDo

Just copied all the records from FileA to FileB.  Between the Read and the 
Write, make any field changes you want.

There are many other options (External Data Structures, etc...) and if the 
above won't work for you let me know and I can give a few other ways I've done 
this in the past.

Regards,

Jim Langston

-----Original Message-----
From: Sean Porterfield [mailto:sporter@bestdist.com]

I wonder if I've missed the obvious...  Don't let my subject mislead you -
I can't use CPYF for my task.

I am basically copying information from one file to another, but some of
the data needs to change, and I need to break out (create) detail records
where there are summary.

I can get all of the detail records.  My question is about copying the
fields from one file to another.  I started with two identical files (as
far as field layout goes.)  I used PREFIX on one so I wouldn't have
conflicting field names in the program.  I was thinking I could just EVAL
NEWFILE=OLDFILE on the format names, but that didn't work.

Can it be done with EXTNAME data structures?

Or do I have to copy each field individually before I can write the
record?  (Is this what the MOVEC vote was for on the ballot?)

Thanks!