I tried using cursors in stored procedure, I guess ISE does not support
dynamic queries/cursors in stored procedure. ISE does not support 'SKIP 5 FIRST 5'

we have thousands of records in our database.
I need to be able to bring first 100 and then the next hundred records, and so on using java..

Please someone suggest me how to do this in an easy and efficient way using
java?? Any suggestion is highly appreciated..

I don't know if Informix SE support the WITH RESUME option on the STORED PROCEDURE and how java will behave with this option...maybe can help you.

Google Translate
WITH RESUME Keyword