Re: file merge dilema

You should be able to include both file names on the PFILE keyword in the
logical.  No need for any join keywords. Like PFILE(PHYSFILE1 PHYSFILE2).

Dave


Sam Kanakanui wrote:

> I'm sure the answer to my problem is easy but I'm not seeing it.  I have a
> need to join 2 PFs and process them as 1.  They are identical in record
> format name, field names and characterisitics.  They both have the same four
> fields defined as a key.  If you put the records from both files together
> you would still have a unique key.   I have been reading about join LFs but
> I don't see an example of this scenario so I am not sure if I can use that
> within DB2.  I know I can copy the 2 files into 1 every time I want to
> process the merged files but of course, that's a lot of overhead.  Does
> anyone have an idea?
>
> TIA
> Sam Kanakanui
> Borg Systems Inc.
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

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