RE: Secondary Keys

Diane,

Sounds like this is what I'm looking for. Can you send me any code
examples? You can e-mail me directly if you prefer.

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



                                                                                
               
                    "Brown, Diane R."                                           
               
                    <DBrown@DoanePetC        To:     "'RPG400-L@midrange.com'"  
               
                    are.com>                 <RPG400-L@midrange.com>            
               
                    Sent by:                 cc:                                
               
                    owner-rpg400-l@mi        Subject:     RE: Secondary Keys    
               
                    drange.com                                                  
               
                                                                                
               
                                                                                
               
                    12/06/00 10:53 AM                                           
               
                    Please respond to                                           
               
                    RPG400-L                                                    
               
                                                                                
               
                                                                                
               




Patrick,

Have you considered using embedded SQL?  You could have a number of SQL
Declare statements in a Select, then based on the user choices, choose the
one that you need.  I use the SQL file as input only, then chain to another
LF (that is over the same PF) for the actual updates.  I have written many
embedded SQL programs if you need examples.

Diane

-----Original Message-----
From: Contractor1@Parkdalemills.com
[mailto:Contractor1@Parkdalemills.com]
Sent: Wednesday, December 06, 2000 9: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
+---