Re: join logical keys by secondary file, any free way around this

Mark,

What about a permanent file that merges the keys from the two files and then
use triggers on the item master and item nbr using file to maintain the
syncronization with the two source files?

-Steve Richter

-----Original Message-----
From: Mark A. Manske <mmanske@minter-weisman.com>
To: MIDRANGE-L (E-mail) <MIDRANGE-L@midrange.com>
Date: Wednesday, June 13, 2001 5:38 PM
Subject: join logical keys by secondary file, any free way around this


>we have a primary file with item number in it, and a itemmaster file with
>the description, because of processor time limitations,
>and the need for instant access (opnqryf on these files takes far too long
>for an interactive program to work, and we do not
>and will not be getting sql is the word from the bean counters)
>
>The dilemma is that according to V4R5 DDS manual, I cannot use fields from
>the "secondary" file as part of the key, but that
>is what I need to do, the primary file must be ordered by customer, date,
>and lastly by item description...
>
>Any ideas how to circumvent this (big file is primary, and for our little
>box, the item mast is not that small either)
>
>I am not really able to just plop the description into this other file
>either, the complexity of a change like that is not
>pretty, and is too time consuming.
>
>Any ideas, or am I just going to have to tell them, too bad, this is in
item
>number order, as even pounding in the ile/rpg
>to a "keyed" work file is too slow too...
>
>TIA
>
>Mark A. Manske
>Minter-Weisman Co.
>Sr. Project Lead
>
>
>+---
>| 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
+---