Replacing Limit x,y with JDBC

[email protected] Wed, 7 May 2003 19:15:43 -0400
Newsgroups gmane.comp.db.sapdb.sources
Message-ID <[email protected]>
Hi,

Am migrating our db from mySQL which has Limit X,Y function, to SAP.

I saw on the list a suggestiong to use

SELECT * from tbl WHERE ROWNO <= 20
  FETCH POS (10) INTO ...            (if you want to see result number 10,
otherwise use 11)
  Loop
    FETCH NEXT INTO ...
  Endloop

But don't see how that will work with a single JDBC call.

Does anyone know how to mimic this with a single call?

Many thanks,

David