Re: Merge of 2 similar files

On 25 Jun 2013 13:58, Hoteltravelfundotcom wrote:

We have 2 files which contains warehouse locations data. They are
basically the same file but each has its record id and all fields
will conform to record id in the first 2 positions.

For reporting purposes, I can use 1 file but by just adding records
one to the other, I get the 2 sets of fields.

Is there a simple way to make this one file with one set of fields
that is instead of AABIN and BBBIN just AABIN.

I think with an RPG program I can write all fields to the new name.
But wondering is there a simpler way.

Given that nebulous description of the scenario, with a dearth of the specifics that should allow someone to offer an intelligent reply that will not be easily discounted\dismissed as impossible due to some restrictions that might be encountered... I believe the obvious solution is to use any non-RPG requests ;-) Any of OPNQRYF, CPYF, FMTDTA, COPY, IDDULINK, DSNQRYAPP, REXX, SQL [procedure result set, UDTF, VIEW, QMQRY, or ?], C, C++, JAVA, or something else might just provide a "simpler way" to effect whatever is desired :-)

I would be more confident in any reply I might offer, for example, if only I could intuit or divine the specifics of the "files", even possibly what are the data\types, and whatever already exists for the reporting purposes; i.e. what that existing feature requires, what form[at], to consume the data. But for the lack of a crystal ball, the actual details would probably be better than what I might conjure.