RE: Secondary Keys

[Buck Calabro <buck.calabro@xxxxxxxxxxxxxxxxx>]

Patrick Conner wrote:

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

OPNQRYF or SQL will do what you require.  Be aware that joins (in any form)
will not allow updating - you'll need to use another access path to perform
the record maintenance.  Performance issues are addressed by creating
logical files with the proper keys.  Both OPNQRYF and SQL will use existing
access paths if they are keyed the way your "query" wants the records.

Buck Calabro
Aptis; Albany, NY
"Nothing is so firmly believed as
 that which we least know" -- Michel Montaigne
Visit the Midrange archives at http://www.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
+---