In my existing application, some RPG programs are reading the data of two different files (Old files) and using that data for comparison purpose in these RPG programs. Now I need to use a different file (New file) instead of the old files. But the new file has to get the data from these old files on matching a primary key field (Common Field in all the 3 files). Remaining fields are different in terms of size and type.
How to get the old files data in this case into the new file in this scenario?
Please reply me ASAP. Thanks!