getting the number of returned rows from a select query

FAQ

Profile

getting the number of returned rows from a select query

Database Forums (Home) -> Informix

Next: Simple update statement (or is it?)

Author

Message

Gentian Hila

External

Since: May 05, 2005
Posts: 2

(Msg. 1) Posted: Thu Feb 11, 2010 5:49 pm Post subject: getting the number of returned rows from a select query Archived from groups: comp>databases>informix (more info?)

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, >> Stay informed about: getting the number of returned rows from a select query

Display posts from previous:

Related Topics:

NETTYPE's poll thread number - Hi, My box has singel processor , NUMCPUVPS =1 . A lot of user will access this server, maximum will be 1500 user threads. How shoud I set up the NETTYPE in onconfig file. On informix's manual , says poll thread should not be greater than NUMCPUVPS ...

Splitting rows without temp tables - This isn't a question as such - I asked that earlier and got prompt and useful help, thanks. But it seemed only fair to share the final solution I built with your help and some other digging, in case someone else trolling the archives finds it useful. ....

Return records where field equals certain number - Hello, I've tried looking for the function, or other way, to return a record where the length of the value in the field equals a certain number. For example, I have a table with a set of items. There is a possibility that each item can have 2 different...

Sql to concatenate multiple rows to a single row / column - Is there a way of concatenating the results from one column / multiple rows into a one column / one row? Problem: I have a patient table with the following columns patid patname allergy table with the following columns patid allergy patid ..

SQL Question: Aggregate several rows in one line? - Dear Informixers, I know this question has been discussed before, but I cannot think of the right keywords to search for what I want to accomplish. Maybe even the subject line is misleading, but I couldn't come up with with anything better, I'm not a..

	Database Forums (Home) -> Informix	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum