Stored procedure returns multiple rows

FAQ

Profile

Stored procedure returns multiple rows

Database Forums (Home) -> Informix

Next: How to thanks for your beloved ?

Author

Message

bonbonthejon

External

Since: Jan 21, 2009
Posts: 1

(Msg. 1) Posted: Wed Jan 21, 2009 6:50 am Post subject: Stored procedure returns multiple rows Archived from groups: comp>databases>informix (more info?)

We are using Informix 10.00. I am trying to clean up some code by writing stored procedures. I want to have a stored procedure that returns multiple rows. I would like to use the stored procedure in a FROM clause, but if I need to get the results in a temp table that is fine. I can use "EXECUTE FUNCTION curr_sess(2009,'SP')" fine. I tried creating a temp table and then doing "INSERT INTO t12 EXECUTE FUNCTION curr_sess(2009,'SP');", but I get a " Illegal SQL statement in SPL routine." error. Any ideas for a new DBA? >> Stay informed about: Stored procedure returns multiple rows

Display posts from previous:

Related Topics:

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

explain plan for stored procedure - IDS 9.40.FC5 Solaris 9 How do I run explain on a stored procedure (SPL)? Can it be done without executing them? thanks

CDR CHECK -R returns error - Hi I am trying to set up an Enterprise Replication on an IDS 10.0 UC5 with tables using clobs and blobs. Everything is working fine including the "cdr check replicate -c server -m master -r repl target" commands, but when I add the -R option ...

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

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