August 29, 2008 10:08pm pdt

1. momi_sa... 149,600
2. Kdo 114,210
3. daveslash 36,236
4. murphey2 11,225
5. ghp7000 9,553
6. tliotta 8,660
7. rward 6,000
8. Lowfatsp... 5,885
9. mark_wills 5,700
10. TomasHelgi 4,000
10. jinesh_ka... 4,000
12. angelIII 3,600
12. giltjr 3,600
14. sdstuber 2,900
15. BillBach 2,800
16. mlmcc 2,600
17. TheLearn... 2,500
18. TextReport 2,375
19. jafastinger 2,370
20. objects 2,000
20. multithrea... 2,000
20. HonorGod 2,000
20. _agx_ 2,000
20. hernst42 2,000
20. aiklamha 2,000
20. anarki_ji... 2,000
20. ghostdog74 2,000
20. samtran0... 2,000
20. Vernster 2,000

1. Kdo 439,524
2. momi_sa... 381,666
3. ghp7000 350,839
4. daveslash 151,882
5. Lowfatsp... 129,197
6. BigSchmuh 97,198
7. tliotta 81,009
8. mglxxx 77,570
9. sachinwa... 74,271
10. bondtrader 44,457
11. db2inst1 40,611
12. shalomc 33,735
13. ocgstyles 32,328
14. granbajo 17,627
15. yongsing 17,097
16. waynezhu 17,092
17. angelIII 14,525
18. askanivg 13,235
19. jdlambert1 12,172
20. murphey2 11,225
21. srielau 10,356
22. dr_marko 8,360
23. giltjr 7,500
24. elfe69 6,300
25. DeanHorak 6,000
25. rward 6,000

06.24.2008 at 02:03PM PDT, ID: 23512641

	[x] Attachment Details

return 2 result sets from a stored proc

Asked by daveslash in DB2 Database, Programming for iSeries / AS400, AS / 400

Greetings, experts!

I have a stored procedure that is supposed to return two result sets, but only one result set is coming back. I verified that both queries return valid data, but (for some reason) only the last result set is returned.

The procedure is actually a C-program (an "external" procedure) with embedded SQL.

Please take a look, and let me know what I'm doing wrong. I'm sure the answer is blindingly obvious, but I've been looking at this for so long that I've lost all objectivity.

Thank you very much!
DaveSlash
Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:

           
           
             CREATE PROCEDURE MyProc (
  ... some parameters ...
)
RESULT SETS 2                                 
LANGUAGE C NOT DETERMINISTIC MODIFIES SQL DATA
EXTERNAL NAME MYPROC
PARAMETER STYLE GENERAL WITH NULLS
 
... some stuff ...
 
exec sql
DECLARE resultset CURSOR FOR
select sectionTitle
from   TTSECTDTLS
;
 
exec sql
DECLARE resultset2 CURSOR FOR
select freeTextID,
       freetextData
from   TTFOOTDTLS
;
 
EXEC SQL OPEN resultset; 
EXEC SQL OPEN resultset2;
 
EXEC SQL SET RESULT SETS CURSOR resultset; 
EXEC SQL SET RESULT SETS CURSOR resultset2;

           
         

Keywords: return 2 result sets from a stored proc

	Title
1	3rd Party Tool or other methods to aut…
2	Oracle PL SQL Store Proc not functioni…
3	Specifying dynamic Table names
4	Stored Proc Logic error. Please Help!
5	Calling a Stored Proc from within a Stor…
6	stored proc date search

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_EXPERT_20070906

return 2 result sets from a stored proc

Asked by daveslash in DB2 Database, Programming for iSeries / AS400, AS / 400

About this solution