Re: getting the number of returned rows from a select query

Thank you very much to both of you who answered, That did the trick. On Thu, Feb 11, 2010 at 6:28 PM, Fernando Nunes <domusonline@gmail.com> wrote: > Please check: > > http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqls.doc/ids_sqs_1488.htm?resultof=%22%64%62%69%6e%66%6f%22%20 > > DBINFO('sqlca.sqlerrd2')> > It shoud give you what you need > Regards, > > > On Thu, Feb 11, 2010 at 10:49 PM, Gentian Hila <genti.tech@gmail.com> wrote: >> >> I am creating a stored procedure (in IDS 9.40)  which among other >> others has a SELECT query. The flow of the procedure depends on the >> number of results returned by the query. >> >> Also the query populates some variables so I have to run a query and >> not a  count query. >> >> Is there any way to get the number of results returned without having >> to run a second query with a count in it? >> >> Thank you, >> _______________________________________________ >> Informix-list mailing list >> Informix-list@iiug.org >> http://www.iiug.org/mailman/listinfo/informix-list > > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >