Result Set

[<SRamanujan@xxxxxxxxxxxxxxxxxx>]

Hi All,
I have a problem with result set. I am try to return a cursor back from
SQLRPGLE (without a fetch), so that I can read it within java and
process the data.  I have the code as follows:

C/EXEC SQL OPEN C1
C/END-EXEC

C/EXEC SQL SET RESULT SETS CURSOR C1
C/END-EXEC

But when I do a rs.next() I get nothing.  Should I have to fetch the
cursor within sqlrpgle?   How can I return/retrieve more than one result
sets?  I think I can just return as SET RESULT SETS CURSOR C1, C2.  Is
this fine? How can I retrieve in java?  For one, I do a ResultSet rs =
stmt.executequery() and then read them with rs.getString(). 

Thanks for all your help.
Sudha

Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax