Re: Secondary Keys

Dan,

When you say "user index" are you talking about a work file with only the
index? I think that will still cause to much of a delay when entering the
application.

Or maybe the light bulb just came on. Are you thinking of building the
index in the morning and maintaining it along with the primary file
throughout the day?

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/06/00 10:58 AM                                           
               
                    Please respond to                                           
               
                    RPG400-L                                                    
               
                                                                                
               
                                                                                
               




It's been awhile, but I do not believe you can define a key field from a
secondary file in a join logical.  My workaround for that has been to use
OPNQRYF to do that, but that may not be practical for an interactive app.

Another possibility for you is to load your data destined for your subfile
into a user index and load the sorted data from there into the subfile.

Dan Bale
IT - AS/400
Handleman Company
248-362-4400  Ext. 4952

-------------------------- Original Message --------------------------

I have a maintenance program that can be displayed with multiple sorts. It
is set up to read different a logical based on what the user keys as a sort
code. However, some information in the subfile is from secondary files and
they want the subfile sorted on those fields. I looked at doing a join
logical, but I can't tell where I'm allowed to use the fields from the
secondary file as key fields. Anyone have any suggestions?

Patrick Conner
www.ConnecTown.com
(828) 244-0822
+---
| 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
+---