Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Fernando Nunes — — source: Usenet: comp.databases.informix
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%20DBINFO('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...
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.