RE: Logical File over identical files in separate libraries.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
Sent: Friday, December 07, 2007 2:38 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Logical File over identical files in separate libraries.

SQL DDL alternative is:

CREATE VIEW myOvercompassingView AS
(
SELECT * FROM lib1/file
UNION ALL
SELECT * FROM lib2/file
UNION ALL
SELECT * FROM lib3/file
UNION ALL
SELECT * FROM lib4/file
UNION ALL
SELECT * FROM lib5/file
UNION ALL
SELECT * FROM lib6/file
)

Elvis

Celebrating 10-Years of SQL Performance Excellence on IBM i5/OS and

www.centerfieldtechnology.com


-----Original Message-----
Subject: RE: Logical File over identical files in separate libraries.

I'm afraid that I don't know enough to answer.

Basically, I want 6 files in different libraries to look like one

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