Re: SQL RPG Access Path Utilization - HELP ??

[Dave Shaw <dshaw1@xxxxxxxxxxx>]

-----Original Message-----
From: Colin Williams <Williamsc@technocrats.co.uk>
To: 'RPG400-Lmidrangecom' <RPG400-L@midrange.com>
Date: Friday, March 26, 1999 1:35 PM
Subject: RE: SQL RPG Access Path Utilization - HELP ??


>You have created new logicals over existing physcals.
>
>OPNQRYF/SQL will either create a new access path or use an existing
>logical with the relevant keys/select-omit it requires if one is
>available, depending on which one is cheapest in performance terms. If
>that just happens to be your logical files, then there you go.
>So yes, if your logical is over a 'LIVE' physical, a producation job
>that uses SQL/OPNQRYF could potentially use your logical that is not in
>its library list!

Note, however, that all it uses is the access path.  It doesn't use the
record format of the logical unless it's specified on the FORMAT parameter
of OPNQRYF, or with SELECT * FROM the logical file in SQL.

---
Dave Shaw, General Nutrition, Greenville, SC
To subscribe to the MAPICS-l mailing list send email to
MAPICS-L-SUB@midrange.com
The opinions expressed may not be my employer's unless I'm sufficiently
persuasive...


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *