RE: Secondary Keys

["Sims, Ken" <KSIMS@xxxxxxxxxxxxxxxx>]

Hi Dave -

>Unfortunately I don't think it works that way.  When you 
>specify a join logical file to the query engine, it actually 
>looks at the underlying physicals to determine whether it 
>needs to build the temporary file or not. If the sort fields 
>come from more than one physical member, it builds the
>temporary file, essentially using the same logic that CPYF 
>uses to copy records from a join logical when CRTFILE(*YES) 
>is specified.

You could be right.  We only have a handful of join logicals, of which I
think I have created zero.  And we don't have many join OPNQRYFs, of which I
have probably created zero also.  (Nor do I use embedded SQL <gag>, I roll
my own join logic in the program.)  So I've never had occasion to actually
see if that would work or not.  And since it's something I don't really care
about, I'm not going to bother and see if I can persuade the query engine.
(But if you want to borrow my hammer ... <G>)

Ken
Southern Wine and Spirits of Nevada, Inc.
Opinions expressed are my own and do not necessarily represent the views of
my employer or anyone in their right mind.



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