Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!wuarchive!husc6!bochner From: bochner@lange.harvard.edu (Harry Bochner) Newsgroups: comp.databases Subject: Re: Number of Rows from an Informix ESQL statement. Message-ID: Date: 15 Dec 89 22:04:36 GMT References: <590@aut.UUCP> Sender: news@husc6.harvard.edu Organization: Aiken Computation Lab, Harvard University Lines: 14 In-reply-to: lincoln@aut.UUCP's message of 13 Dec 89 15:54:50 GMT I don't know about ESQL, but from Informix 4gl there really doesn't seem to be a way to get at the number of rows found. If you really have to know you're forced to do a "select count(*) ...", first. That would be OK, except that it's slow. Maybe there's some system variable that contains the answer? Not as far as the manuals tell us ... What really irks me about this is that you can tell that the internals do return the answer: the preprogrammed Query-By-Example processor (perform) always informs you of the number of rows, and clearly doesn't spend any extra time on it. They've got the information, but didn't provide a 4gl interface to it. Harry Bochner bochner@endor.harvard.edu