RE: Secondary Keys

[Contractor1@xxxxxxxxxxxxxxxxx]

Good point.

Patrick Conner
www.ConnecTown.com
(828) 244-0822



                                                                                
               
                    D.BALE@handleman.                                           
               
                    com                      To:     RPG400-L@midrange.com      
               
                    Sent by:                 cc:                                
               
                    owner-rpg400-l@mi        Subject:     RE: Secondary Keys    
               
                    drange.com                                                  
               
                                                                                
               
                                                                                
               
                    12/07/00 02:46 PM                                           
               
                    Please respond to                                           
               
                    RPG400-L                                                    
               
                                                                                
               
                                                                                
               




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




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