Re: Join 2 Logical Files

["alan shore" <SHOREA@xxxxxxxx>]

Try using a join (inner, outer or partial) using the CL command OPNQRYF. I'm 
assuming there is some key or keys common to both files. The result of this is 
one file that can be read from beginning to end, or use the natural cycle.

>>> <Gade_R_Reddy@consecofinance.com> 01/13 2:41 PM >>>

Hey Guys,

I have two logical files and my report is based on the union of all the
data  from these two logical files.

Now in my program i read the two logical files from BOF to EOF & created a
physical file with the all data from the logical files & drive the report
from there.

Please suggest are there anyways to get the union of two logical files and
how are SQL Views more advantages than Logical Files????

Thanks.
Gade.


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com 
+---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---