Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!usc!jarthur!aqdata!sullivan
From: sullivan@aqdata.uucp (Michael T. Sullivan)
Newsgroups: comp.databases
Subject: Re: Number of Rows from an Informix ESQL statement.
Message-ID: <1989Dec19.203459.10607@aqdata.uucp>
Date: 19 Dec 89 20:34:59 GMT
References: <2854@infmx.UUCP>
Organization: aQdata, Inc.  Western Region -- San Dimas, CA
Lines: 14

From article <2854@infmx.UUCP>, by aland@infmx.UUCP (Dr. Scump):
> 
> Since the number of rows in a cursor can change (depending on what
> isolation level is in effect), the OPEN and FETCH statements *do not*
> set sqlerrd[x].  If you *have* to know the approximate number of rows 
> in advance, you can run a select count(*) from ... using the same 
> WHERE clause.

Somebody else mentioned perform and I am curious about it as well.
How does a query in perform know how many rows are returned by a query?
-- 
Michael Sullivan          uunet!jarthur.uucp!aqdata!sullivan
aQdata, Inc.
San Dimas, CA