Re: Retrieving 1, and only 1, row in SQL

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

Might look weird, but have a single-record dummy file.

'select * from dummy where exists (Select dbname from qsys2/syscolumns +
                     where DBNAME = ? +
                       and TBNAME between ? and ? +
                       and NAME   between ? and ?)';

As soon as the subquery finds a record, it should stop and the query is
done. You'll get a single record, not of the data itself, just a signal
that your field or whatever, exists.

At 04:44 PM 3/15/02 -0500, you wrote:

>What do you mean by 'where exists'?
>
>Rob Berendt
>--
>"They that can give up essential liberty to obtain a little temporary
>safety deserve neither liberty nor safety."
>Benjamin Franklin
>
>
>
>                     Vernon Hamberg
>                     <vhamberg@attbi.com       To:     midrange-l@midrange.com
>                     >                         cc:
>                     Sent by:                  Fax to:
>                     midrange-l-admin@mi       Subject:     Re: Retrieving
> 1, and only 1, row in SQL
>                     drange.com
>
>
>                     03/15/2002 03:58 PM
>                     Please respond to
>                     midrange-l
>
>
>
>
>
>
>Alexei makes a good point. Maybe 'where exists' would be better, if it
>works as I hope it does, viz., that it stops as soon as it finds a match.
>
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.