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

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...