Re: A probably stupid Question....

[Jim Langston <jimlangston@xxxxxxxxxxxxxxxx>]

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