Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!tut.cis.ohio-state.edu!purdue!iuvax!rutgers!aramis.rutgers.edu!paul.rutgers.edu!emuleomo From: emuleomo@paul.rutgers.edu (Emuleomo) Newsgroups: comp.databases Subject: Re: Number of Rows from an Informix ESQL statement. Keywords: esql, informix, sql, no snow. Message-ID: Date: 15 Dec 89 04:30:09 GMT References: <590@aut.UUCP> Organization: Rutgers Univ., New Brunswick, N.J. Lines: 22 In article <590@aut.UUCP>, lincoln@aut.UUCP (Philip Lincoln) writes: > Hello world, > This may be your basic stupid question, or I may be > justified in asking it, but: > How can (if it's possible) you tell the number of rows > returned by an Informix-ESQL "open" statement that runs a > declared select query?? i.e. the number of rows in the > active set. The manual has been no help. > > Thanks, > Philip. That usually can be found in the sqlca struct that you include as a header file in your source code. I don't have the manual handy, but if you look in the manual, it explains what each fld of that sqlca struct means. Happy digging --Emuleomo O.O. (emuleomo@yes.rutgers.edu) -- ** The ONLY thing we learn from history is that we don't learn from history!