Re: Merging Files

Very cool, Jerry - glad it worked. Of course, there are the caveats others have 
mentioned that I left out, especially those connected with logicals based on 
files in different libraries. But you've been around enough to know where to 
look for help in that arena.

Vern
-------------- Original message -------------- 
From: Jerry Adams <jerry@xxxxxxxxxxxxxxx> 

Vern, 


I set up a quick test LF. Physicals in multiple libraries. Worked 
fine. Even processed a document to add to the current year's history 
and it showed up in the multi-format LF. The only problem was a much 
older PF (2001) that is missing a field common to all of the other PFs 
I think I can live without flashbacks to 2001! So life is (temporarily) 
good. 


Thanks. 


* Jerry C. Adams 
*IBM System i Programmer/Analyst 
B&W Wholesale Distributors, Inc.* * 
voice 
615.995.7024 
fax 
615.995.1201 
email 
jerry@xxxxxxxxxxxxxxx 



Vernon Hamberg wrote: 

Hi Jerry 

I'm trying to remember if this is possible - have a single format in 
the LF but name several files in the CRTLF command - not sure if it 
can cross library and file boundaries - it can definitely merge 
several members of the same file in one logical. All the Pfiles have 
to have the same format, of course - I think. 

HTH 
Vern 

At 07:30 AM 6/21/2006, you wrote: 

Thanks to everyone. 


I do have a project to merge all of the tables into a single table. 
Legacy code, especially queries, are going to be a pain. 


I definitely need to get into SQL more; I pull out Conte and Cravitz's 
book whenever there's down time. I use pretty simple statements, such 
as Select and Update, frequently but need to become better versed in the 
subject. I'll read up on the Union as soon as possible. 


Scott's solution for legacy code was what I was trying to do, except 
that I had defined multiple record formats, such as 

R FORMATR PFILE(PF1) 
K KEY 
R FORMATR PFILE(PF2) 
K KEY 


Which was the way the DDS manual and InfoCenter both illustrated it. 
But their examples were merging, say, an Order Header and Order Details, 
not identical tables. The DDS compiler choked on that, obviously. 


Again, thanks. 

* Jerry C. Adams 
*IBM System i Programmer/Analyst 
B&W Wholesale Distributors, Inc.* * 
voice 
615.995.7024 
fax 
615.995.1201 
email 
jerry@xxxxxxxxxxxxxxx 



John Candidi wrote: 

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? 

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options, 
visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
or email: MIDRANGE-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/midrange-l. 

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options, 
visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
or email: MIDRANGE-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/midrange-l.