RE: Secondary Keys

["Brown, Diane R." <DBrown@xxxxxxxxxxxxxxxx>]

Yes, you will have the same performance problems as OPNQRYF.  I would still
create the join LF for performance and the SQL will use that LF.  I prefer
the SQL to OPNQRYF because I can close the cursor and select another sort
without ever leaving the RPG.  

-----Original Message-----
From: BEllis@oriental.com [mailto:BEllis@oriental.com]
Sent: Wednesday, December 06, 2000 1:59 PM
To: RPG400-L@midrange.com
Subject: RE: Secondary Keys



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