Re: Returning Result Sets from SQLRPGLE - positioning the cursor

[meovino@xxxxxxxxxxxxxxxxx]

Thanks!  All I want to do is display it in a JSP, so this should be fine.
 
Mike E.






"Schadd D Gray" <list@xxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
06/30/2004 02:50 PM
Please respond to RPG programming on the AS400 / iSeries
 
        To:     "RPG programming on the AS400 / iSeries" 
<rpg400-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Re: Returning Result Sets from SQLRPGLE - 
positioning the cursor



Here is an example for your second question.  You may be able to position 
to
a record using rs.absolute().  I have never tried it.  Remember that a
result set from a stored procedure is forward read only.

con = new Connection();
cs = new CallableStatement();
rs = new ResultSet();
cs = con.prepareCall(call mylib.pgm1 (?,?));
// set the input parms
cs.setString(1, getEnvironment()); // Environment
cs.setString(2, ordLine.toString()); // Array
// execute the stored procedure
rs = cs.executeQuery();
while (rs.next())
{
...some code here
}

rs.close();
cs.close();
con.close();

Regards,
Schadd Gray
Damon Technologies, Inc.
Stored Procedure Test Environment
www.damontech.com

----- Original Message ----- 
From: <meovino@xxxxxxxxxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Wednesday, June 30, 2004 10:47 AM
Subject: Returning Result Sets from SQLRPGLE - positioning the cursor


> We're getting into using embedded SQL in RPG programs to return result
> sets to Net.Data macros.  It works great.  We've figured out how to 
return
> the entire result set, but how do we limit the result set to the first 
'n'
> rows and then how do we get the result set to start at row 'n + 1' and
> return 'n' more rows?
>
> What we're looking to do is page through large result sets rather than
> display them all at once.  When using SQL in Net.Data, we used the
> START_ROW_NUM and RPT_MAX_ROWS variables to page through result sets.
>
> Here's what we're doing to return a result set:
>
> c/exec sql
> c+ declare C1 cursor for
> c+
> c+ select *
> c+ from filename
> c+ where fieldname = :value
> c+ order by fieldname
> c+
> c+ for fetch only
> c/end-exec
>
> c/exec sql
> c+ open C1
> c/end-exec
>
> c/exec sql
> c+ set result sets cursor C1
> c/end-exec
>
> Also, does anyone know if can we call an SQLRPGLE program that returns a
> result set from a Java servlet, so we can use JSP's to format and 
display
> the result set?
>
> Thanks!
>
> Mike E.
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing 
list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.