Re: Logical File over identical files in separate libraries.

["Francis Lapeyre" <flapeyre@xxxxxxxxx>]

Interesting. We had to do it that way because we needed to determine which
database the record came from. I just ass-u-me-d you had to have different
formats. Live and learn.

On Dec 8, 2007 8:57 AM, Jerry Adams <jerry@xxxxxxxxxxxxxxx> wrote:

> No they do not.  I have a history table segregated into different
> libraries by year.  They all have the same record format.  I merge them
> into a single keyed logical via:
>
> R BWDNAMR                   PFILE(HIST2002/BWDNAM)
>                            PFILE(HIST2003/BWDNAM)
>                            PFILE(HIST2004/BWDNAM)
>                            PFILE(HIST2005/BWDNAM)
>                            PFILE(HIST2006/BWDNAM)
>                            PFILE(HISTORY/BWDNAM)
>
> (key fields follow)
>
> The one thing that might bite is a backup of the library into which the
> LF is built (in this case HISTORY).  The backup will work, but the
> restore cannot restore the LF.  So I always delete the LF beforehand and
> rebuild it after the restore.
>
>        * 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>
>
>
>
> Francis Lapeyre wrote:
> > Yes. You have to have different record formats for each file, and the
> PFILE
> > keyword needs to be qualified with a library name. So when you process
> the
> > file, you can do so either by record format (to get info from a specific
> > library), or by file name (to get global information).
> >
> > On Dec 7, 2007 1:54 PM, Thompson, Glenn <gthompson@xxxxxxxxxxxxx> wrote:
> >
> >
> > > Is it possible to build a single logical file over identical physical
> > > files in different libraries?
> > >
> > >
> > >
> > > Glenn Thompson
> > >
> > > Senior Analyst
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > 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.