SQL Existence Check

[peteh@xxxxxxxxxxxxxxxx (Pete Hall)]

In message <01bcf122$0fddafa0$0100007f@localhost>, From "Walden 
Leverich" <walden@techsoftinc.com>, the following was written:
> I would like to check for the existence of a record in a file using 
> SQL. There could be 0, 1 or more than 1 records that match the 
> selection criteria, I only care if records exist, not how many.

You could use select count(*). If it's greater than 0, then it exists.
I've resorted to this a few times when working with SqlAnywhere. I
suspect it might not perform as well as a more traditional approach such
as RPG's SETLL op code with a resulting indicator, particularly if there
are multiple records.

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 MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---