var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Multi resultset
Does anybody know how can i return several resultset?
I have several temporary tables, and I want return those all as resultset. I can do it for a single table, but how to do it with several tables?
Thanks in advance.
Not entirely sure what you want to do here - I assume you want a single result set with all the tables in? This is only possible if you're tables have the same column types...
select stuff, stuff2, stuff3
select stuff4, stuff5, stuff6
select stuff7, stuff8, stuff9
order by 3
(I have a feeling this isn't what you're after though. if it's not, you have to have separate selects and separate result sets for each).
Yes, I want to return separate result set. How can I do that?
Your language will vary, of course, but the general way would be...
Recordset1 = Connection.getResultSet(" select * from customers ");
Recordset2 = Connection.getResultSet(" select * from bank_details ");
Recordset3 = Connection.getResultSet(" select * from orders ");
I can't do it that way. Thanks anyaway.
please, be more clear! give more details!
What language are you using?
what version of IDS?
What the difficult to fetch a SELECT? this is a basic thing for any application that access a database....
The IDS version is 11.50 FC1. I'm doing stored procedures, and I was trying to return several different result set, but it's not possible to do it with informix IDS. That is a feature it simply doesn't have.
I need to reach it using another approach.
I don't have much time to help with details now , try work with WITH RESUME:
WITH RESUME Keyword
Plus the TABLE operator...
Look this page : Utilizar uma stored procedure em um select no lugar de uma tabela | IMartins
Is in Portuguese , but the Informix code are the same...
César, I'm portuguese, hence there are no problem.
I know work with the keyword WITH RESUME.
Anyway, that can't help me. However TABLE it's a nice funcionality.