Re: file merge dilema

["Peter Dow" <pcdow@xxxxxxxxx>]

Hi Sam,

It sounds like you're looking for a multi-format logical file, not a join
logical. There's a sample in the DDS manual. The only problem is that since
your record formats are named the same, you will have to specify a new
format name for the 2nd format, and you will have to specify all the fields
for that new format, which you can do fairly simply by copying the DDS for
it from the PF's DDS.

HTH
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax


From: Sam Kanakanui <kanakanuis@mindspring.com>
> 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?

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


__________________________________________________
Do You Yahoo!?
Thousands of Stores.  Millions of Products.  All in one place.
Yahoo! Shopping: http://shopping.yahoo.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
+---