If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: how to limit a result set start point

I'm just converting to DB2 8.1 right now and I'm having a hard time finding any information at all on how (or if it's possible at all) to limit a result set to a start_index and items_to_return.

I've found "fetch first N rows only" which is would solve items_to_return, but so far the only way I've found to do start_index is to just keep calling next() on the result set. (Yes I'm using java/JDBC)

As an example in mysql there's a thing called "limit x,y" where x is the starting row # and y is the number of rows to return. Is there such a thing in DB2?