Re: SQL select via logicals

[Vern Hamberg <hambergv@xxxxxxxxxxxxxx>]

Dean

At 11:40 PM 12/5/97 EST, you wrote:
>Vernon,
>
>In a message dated 97-12-01 16:30:57 EST, you write:

-snip-

>I don't know about the columns, we have all of them specified in all logical
>files.  Security in the latter instance is determined by program access.  I
>disagree with the ROWS statement.  I believe that it is possible for SQL to
>choose a logical other than the one specified, thus invalidating all row
>selection assumptions.

>From what others are saying and demonstrating, it seems that what you
suggest, will not happen—a less restrictive WHERE clause will not return
more records than are available in the logical.

Cheers

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN 55401
(612) 371-1111 x480


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