• Subject: Re: SQL select via logicals
  • From: DAsmussen <DAsmussen@xxxxxxx>
  • Date: Sat, 29 Nov 1997 20:38:22 EST
  • Organization: AOL (http://www.aol.com)

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


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].