Re: SQL select via logicals

[DAsmussen <DAsmussen@xxxxxxx>]

Chris,

In a message dated 97-11-27 17:33:43 EST, you write:

> >  Specifying a logical file in your SQL statement _DOES NOT_ guarantee that
>  > the chosen logical will be used.
>  
>  Thank you very much for this tidbit. 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. 
>  
>  That opens a bunch of issues for me, when considering remote access to a
data
>  base by an SQL using client.

Yes, _MOST_ people make that same assumption.  I always advise people to base
their SQL upon the physical, because the WHERE and ORDER BY clauses will
always be considered against the same existing logicals as they would if you
specify a logical in the SELECT clause.

Regards!

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@aol.com

"The two hardest things to handle in life are failure and success." -- Unknown

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