RE: Merging Files

Not sure how many files are in each library and not sure of the size of your
files so this may not be an option, but I have some files like that that I
wrote a query for that appends the file for one year to another year and I
write the year to the beginning of each file. In the end, I have one big
file with multiple years. Of course, you can always create a view across the
years like someone mentioned

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jerry Adams
Sent: Tuesday, June 20, 2006 3: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?