Re: Merging Files

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

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 <mailto: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.