RE: Merging Files

If this was SQL you could do it with a UNION, maybe you could define a
view that was the union of all of the files in question and then do your
reads against that? I honestly don't know who well RPG F spec work with
SQL views.

Chris

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jerry Adams
Sent: Tuesday, June 20, 2006 4:51 PM
To: Midrange-L
Subject: Merging Files

We have separate libraries for each year's history.  In order to perform

inquiries across multiple years rather than multi-defining each PF in 
the program (which, honestly, is what I have been doing), I would like 
to read them as a single file.



These tables have the same identical layout (fields, format names, file 
names); just in different libraries.  I tried using a multiple format LF

but, naturally, it blew off because the record format names are the
same.



Is there any way to read these two physical files via a single file 
statement, or am I just spinning my wheels in the sand here?