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

[Jim Langston <jimlangston@xxxxxxxxxxxxxxxx>]

Consider making your own index file.  A file that would contain the key
information you are looking for as a physical file.  And then contain the
record number or key for the primary file.  

Messy, yes, but it should work, but you are going to have to maintain your
index file.

For example, say you primary file contains:
Branch   Part Number   Quantity   On order
you second file contains:
Part Number   Description

And you really want it to be sorted on 
Branch   Description  Part Number

Well, you create a permanent work file that contains
Branch   Description   Part Number

And copy into this file the data from the other two files.

Now, open this file as your primary, and your other two files as secondary.

Like I said, not clean, not nice, pain to maintain, but it works.


Date: Thu, 14 Jun 2001 10:11:25 -0500
From: "Arlene M Soderlund" <Arlene_M_Soderlund/NFCNA.COM@nfcna.com>
Subject: RE: join logical keys by secondary file, any free way around this

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


JDUPSEQ   is what you want to take a look at. It might solve your problem.
+---
| 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
+---