Re: Secondary Keys

[Scott Klement <klemscot@xxxxxxxxxxxx>]

Can I assume by "secondary file" that you are currently using
primary/secondary files with matching record logic?

If you replaced this with a join logical, you'd only have one file on
your F-spec to read, instead of two like you have with primary/secondary
file logic.   All the fields you need from your PFs are combined into
one record.   The records can be keyed by fields from either file or
both, and this is set up in your DDS for the join logical file.

You might also consider simply sorting the data in your subfile, rather 
than re-reading the file each time.   If its a small, multiple-page-load,
subfile, this could be faster and save you a lot of anguish.  Of course,
it wouldn't work on a single-page-load subfile, and might not be 
practical on a large subfile.

On Wed, 6 Dec 2000 Contractor1@Parkdalemills.com wrote:

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