Re: SQL select via logicals

[peteh@xxxxxxxxxxxxxxxx (Pete Hall)]

In message <199711272046.UAA171368@out1.ibm.net>, From Chris Rehm 
<Mr.AS400@ibm.net>, the following was written:
> I would have made the opposite
> assumption, feeling that if I specified a logical it was because the 
> records I wanted from the file were are subset of that logical. 

Chris,

You're safe here. Even though QQQQuery might use a different access path
to improve performance, it will only return rows that are included in
the access path that you specify, and the columns that are returned will
always be based on the view that you specify.

Pete


--
 - Pete Hall peteh@earth.inwave.com
http://www.inwave.com/~peteh/

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---