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

Hmm, Mike, interesting thought, here is the web app, show them basically
order headers, they click
on the date to see detail in the next cgi program - I have used data queue's
before, but with only
one record and the fifo sequence - cool concept, let me ask this then; and I
am thinking out loud -
my detail html/cgi could read the file; chain to itemmast, write the data
queue records, then "chain"
to it, "records" drop out, so this functions like a "qtemp" file (no
clearing up or worry about locked
file)  Now the question, as I look over manuals, they are vague, say I have
10 people over the web
looking at header records, they click for detail, I write out these keyed
data queues, I do not see
how to read in only the correct ones for each user (as I already know qtemp
is a moving target)
I also know I would have to code for locked data queues, with re-try logic -
the detail could be from
3 records to 150 per order (very rare over that), so does it still sound
feasible, as this is a way
to use data queues that I have not tried before.  Thanks for the insight.

And as for Eric on the sql not being a limit, hmm, we do not have sql, nor
will be be getting it,
my assumption (right or wrong) is that we then do not have the sql
pre-compiler either (do we?)
I know I cannot compile rpgsql type programs, but we can run basic sql
commands... hmm more testing..

Other funky dilemma (the order file has the item number as 6/0 the itemmast
is keyed as 7/0, here is
an example of what the item# looks like 123456 equals the itemmast key of
1234560 (they dropped the
last digit in some files, real bright design here...)....Tested out our
runsql option, I will have to
see what that can do, if anything, so far I can only display the records,
not sure about reading
them into an rpg.. will have to try, the interactive sql runs in about 5-10
seconds, might be ok
for the web, somewhat slow just for file access, but it is better then the
attempt at changing all
the programs updating/creating the detail file to include the item
description in it...

Thank you again for the help and suggestions




-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Mike Naughton
Sent: Thursday, June 14, 2001 8:44 AM
To: MIDRANGE-L@midrange.com
Subject: Re: RE: join logical keys by secondary file, any free way
around this


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

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