Join Logical

[Skittle]

Is there a way to create the equivalent of a UNION ALL logical on the AS400?

In SQL I have created a LF as:

CREATE VIEW MyLib/MyFile AS
SELECT blah blah
FROM LIBRARY1/FILE1
UNION ALL
SELECT blah blah
FROM LIBRARY2/FILE1

It creates a logical file.
Is there a way to do this so I have a QDDSSRC source file?





Dazed and confused
(N+, MCAD)

 

[Mercury2]

Yes : JOIN FILE though SQL's my preference by far.
A join logical file is a logical file that combines (in one record format) fields from two or more physical files.
Check out "Basic concepts of joining two physical files" at IBM site :

http://minilien.com/?7I2EfM8Ton