RE: Secondary Keys

[Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>]

Are all the Key fields in one file for the sort in question?  Are you trying
to sort by multiple fields at the same time?  IF you are only sorting on
fields in one file at a time, though the user can select to sort by A or B
or C and they could be in different files is to create the join with the
secondary file first.  What I mean is to reverse the order of the join in
creating the LF.  That is if the data will allow it.  I don't know your data
bases therefore can only guess if it is possible.

Now if you are joining file1 to file2 on field a but need it sorted by b/c/d
and b & c are only in one file with d in the other.  Create the LF with the
keys B & C.  Then use OPNQRYF with a sort by B & C & D, but force a record
selection such as for product group A only.  That is how we went about it.
Queries can take 10 - 30 seconds depending on how many records meet the
selection criteria.
 

Christopher K. Bipes    mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst  mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.        http://www.cross-check.com
6119 State Farm Drive   Phone: 707 586-0551 x 1102
Rohnert Park CA  94928  Fax: 707 586-1884

If consistency is the hobgoblin of little minds, only geniuses work here.
Karen Herbelin - Readers Digest 3/2000
+---
| 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
+---