RE: Secondary Keys

[BEllis@xxxxxxxxxxxx]

If I understand this correctly.  The Embedded SQL solution is going to have
the same performance issues as an OPNQRYF. It will have to build the keyed
index on the fields in the secondary file from the join logical on the fly
the same as if an OPNQRYF statement would.




                                                                                
                 
                    Contractor1@Parkdal                                         
                 
                    emills.com                 To:     RPG400-L@midrange.com    
                 
                    Sent by:                   cc:                              
                 
                    owner-rpg400-l@midr        Subject:     RE: Secondary Keys  
                 
                    ange.com                                                    
                 
                                                                                
                 
                                                                                
                 
                    12/06/2000 11:39 AM                                         
                 
                    Please respond to                                           
                 
                    RPG400-L                                                    
                 
                                                                                
                 
                                                                                
                 





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



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