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

I like Jim's suggestion, except for the "messy" part. To fix that aspect, consider creating the index file you need and then have a trigger on the big files so that changes there are automatically reflected in your file.

By the way, the request seems very mundane and ordinary. It'd be my guess that your problem has surfaced twice a month for as long as that design has been in your shop. Creating a good fix right now may give lots of payback in User Responsiveness.

_______________________
Booth Martin
Booth@MartinVT.com
http://www.MartinVT.com
_______________________

Jim Langston <jimlangston@conexfreight.com>
Sent by: owner-midrange-l@midrange.com

06/14/2001 01:17 PM
Please respond to MIDRANGE-L

To: MIDRANGE-L@midrange.com
cc:
Subject: RE: join logical keys by secondary file, any free way around this

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

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.