Re: Join 2 Logical Files

[boothm@xxxxxxxxxxxxxxxxx]

Why not process the two files and print the report as you go?  RPG is 
particularly good for that.
_______________________
Booth Martin
boothm@earth.goddard.edu
http://www.spy.net/~booth
_______________________




Gade_R_Reddy@consecofinance.com
Sent by: owner-rpg400-l@midrange.com
01/13/2000 02:41 PM
Please respond to RPG400-L

 
        To:     RPG400-L@midrange.com
        cc: 
        Subject:        Join 2 Logical Files



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