Re: A probably stupid Question....

As stated, you can use the RENAME and PREFIX keywords in an RPG program
to be able to open both files.

But, if you are just going to be reading a record then moving the data
to the new formatted fields and writing the data, you don't have to do
this.

The CPYF command has a parameter for FMTOPT (Format Option) that may
work for you.  Try *MAP which maps fields from one file to the other.
If you specify *DROP in addition, then any extra fields in the from file
won't cause an error.

I would try this and see if it works for you, if it doesn't, then go the
RPG route.

Regards,

Jim Langston

Me transmitte sursum, Caledoni!

EThompson@uafc.com wrote:
> 
> I am doing file conversions and have a problem.  I have two files with the
> same name, same record name and same field names.  However, some of the
> field definitions have changed, ie a 4b,0 field has become a 6A field.  I
> can obviously change file naes with OVRDBF commands and rename record
> names, but is there anyway that anyone knows of that will make this easier
> than having to internally define one of the files to rename the fields to
> map between the two files?  Some of the DDS files are short so internally
> defining them would not be a problem, but some of them have DDSs that are 8
> pages long, etc which for only having to change 2 or 3 fields seems like a
> lot of wasted work to me.
> 
> Elonna
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---