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

["Mike Naughton" <mnaughton@xxxxxxxxxxxx>]

Hi Mark,

You don't say what the application is, but if you're looking to display
(or print) a smallish number of records in this sorted order, you might
consider a keyed data queue. Basically, the idea is that you set up the
data queue with the key structure that you want; then your program writes
the appropriate records into the data queue, and when it reads them back
they are in sorted order (so you can fill your subfile, print  your
report, etc.).

If you're looking to do this with a large number of records, it might be
too slow, but I thought I'd suggest it. . . .

Good luck!

MIDRANGE-L@midrange.com writes:
>Could you create a logical file (I don't know this for sure in native
>mode)
>that spans both files? Like an SQL join?
>
>-----Original Message-----
>From: Mark A. Manske [mailto:mmanske@minter-weisman.com]
>Sent: Monday, June 11, 2001 18:11
>To: MIDRANGE-L (E-mail)
>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


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.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
+---