Returning Result Sets from SQLRPGLE - positioning the cursor

[meovino@xxxxxxxxxxxxxxxxx]

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.