RE: Secondary Keys

[D.BALE@xxxxxxxxxxxxx]

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