RE: Secondary Keys

[Contractor1@xxxxxxxxxxxxxxxxx]

Stan,

Thanks, but I do have a 'Position To:' function built into my sort
selection. It positions based on the values keyed in by the user. If I read
to the position based on the values keyed, I have the same problem as
building a work file except the problem occurs when positioning during the
application instead of once at the beginning: The delay will take too long.
So, I don't think JDUPSEQ is going to do it for me.

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



                                                                                
                   
                    "MCPARTLAND, Stan"                                          
                   
                    <stanley.mcpartland@b        To:     
"'RPG400-L@midrange.com'"                 
                    ently.com>                   <RPG400-L@midrange.com>        
                   
                    Sent by:                     cc:                            
                   
                    owner-rpg400-l@midran        Subject:     RE: Secondary 
Keys                   
                    ge.com                                                      
                   
                                                                                
                   
                                                                                
                   
                    12/06/00 11:57 AM                                           
                   
                    Please respond to                                           
                   
                    RPG400-L                                                    
                   
                                                                                
                   
                                                                                
                   




Patrick,

You can't specify fields from the secondary files as key fields, but you
can
have them sequenced by using the JDUPSEQ keyword.  This works great if you
don't need to establish file cursor position based on the fields in the
secondary files.  If you must establish cursor position the JDUPSEQ keyword
helps, but you must read until you reach the appropriate record.

Regards,
Stan McPartland

-----Original Message-----
From: Contractor1@Parkdalemills.com
[mailto:Contractor1@Parkdalemills.com]
Sent: Wednesday, 06 December, 2000 7:26 AM
To: RPG400-L@midrange.com
Subject: Secondary Keys



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




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