Re: Logical File over identical files in separate libraries.

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.