Re: SQL Existence Check

[Vern Hamberg <hambergv@xxxxxxxxxxxxxx>]

Walden

At 12:23 PM 11/14/97 -0500, you wrote:
>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.
>
>I know that SQL has the EXISTS predicate, but I cannot use it by itself, it
>must be in the where clause of a statement. I realize that I could do a
>select count(*) where.... but this would require DB2/400 to read all the
>matching records in order to count them. In my case as soon as DB2 finds 1
>record it can stop looking.

Is this embedded SQL? If so, FETCH and check the return code. Doesn't -100
mean no more records?

If not embedded, I'll have to think about it some more.

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