RE: Secondary Keys

Dan,

I believe this request has been submitted to IBM repeatedly since the early
days of the /38, but they haven't been able to deliver it yet.  I don't know
what the technical obstacles are, but I'm not optimistic about ever getting
it.  Since SQL's concepts of permanent "Views" and "Indices" don't provide
for anything quite like a keyed join logical, I wouldn't expect it to appear
from that quarter.

Dave Shaw
Spartan International, Inc.
Spartanburg, SC
To subscribe to the MAPICS-L mailing list send email to
MAPICS-L-SUB@midrange.com or go to www.midrange.com and follow the
instructions.

-----Original Message-----
From: D.BALE@handleman.com [mailto:D.BALE@handleman.com]

Patrick, I know you've moved on with this, but you asked:

>Should we be asking for an enhancement to the database
>that will allow fields in the secondary files to be used
>as key values.  Or is this not technically possible?

IMHO, yes, we _should_ be able to specify key fields from non-primary files
in
the join logical.  It can be done in OPNQRYF, in WRKQRY, and, I imagine, in
SQL.  I think this should have been made available in DDS a long time ago.
Alas, it may be too late to get IBM to do anything with it now, since all
enhancements appear to be made to SQL and not DDS.  For better or for worse.

Dan Bale
IT - AS/400
Handleman Company
248-362-4400  Ext. 4952
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---