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,

Please check:

http://publib.boulder.ibm.com/infoce...%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 (AT) gmail (DOT) com> wrote:



--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

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 (AT) gmail (DOT) com> wrote: