RE: Best Practices question on processing 2 files, read or select?

I'm not sure of what you are trying to do but using a left outer join
will give you all of the records in the 1st file and those that match in
the second (this operated like a type 2 join in query).  If you have
records in the 2nd file that do not exist in the first then you can do
an exclusive join of file 2 to file 1 (this operates like a type 3 join
in query) to find records that only exist in file 2, 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Thomas Gard
Sent: Wednesday, January 17, 2007 11:19 AM
To: RPG400-L@xxxxxxxxxxxx
Subject: Best Practices question on processing 2 files, read or select?

I have 2 transaction files with similar data in them, same key,
different transactions, both with a $ amount.  I need to process both
files and get the amount data.  I was either going to read through the
customer list and then go to both files and get the desired data by key,
but I already have a program that uses embeded sql and builds a cursor
for 1 file, I would like to add the extra file to the cursor.
Its not clear to me if this is even possible, I dont want an inner join,
but an additional file to select from that will also add to the cursor.

Thanks.
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.