Re: Join 2 Logical Files

["David Morris" <dmorris@xxxxxxxxxxxxx>]

Gade,

This is pretty strait forward in SQL.  With SQL you get 
the ability to specify join criteria at the file level 
rather than the statement level.

The general syntax for what I think you are asking is:

Select * from filea union all select * from fileb order by key

David Morris

>>> Gade_R_Reddy@consecofinance.com 01/13/00 12:41PM >>>

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