|
midrange.com
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
+---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
