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@xxxxxxxxx> 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@xxxxxxxx
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...

Relevant Pages

  • How to query Kernel how it would route packets?
    ... I am currently developing a Signaling Protocol instance, ... signal along a IP "Flow". ... Thus I have addressing information the like ... but I found still no way to query the kernel programmatically from a C++ ...
    (comp.os.linux.networking)
  • Re: Microsoft Access Expression Problem
    ... separate query and then link the two queries together in a third query. ... SELECT SITENO ... Save both these queries and then join them together as if they were tables ... This return a table with the SITE_NO, DATE, FLOW, and 7dayavg as ...
    (microsoft.public.access.queries)
  • Re: Multiple datasets in one dataset
    ... I am sorry about the late response. ... Here is the master view. ... This is the abstractly defined process flow. ... The problem is to define a query where I get all in one ...
    (comp.databases.oracle.misc)
  • Re: Autonumber in query
    ... These are for beginning and ending odometer readings for ... I need to make sure that they flow, ... I have the query sorting them by ... >What is it that having a recordID on your query results ...
    (microsoft.public.access.queries)
  • Re: Query to retrieve n rows that add up to a certain value
    ... But I donīt need it to iterate. ... It shoud start taking records from the top ... (considering they have been orderded by the field "life") ... > Such a query could be written but in any reasonable sized table, ...
    (microsoft.public.access.queries)