Hi,

I have the following query.

SELECT PUTDATE, PUTTIME, MSGID, MSGTYPE FROM DB2A.MQMD WHERE TSTAMP BETWEEN '2004-04-20-10.00.00' AND '2004-04
-20-10.20.59'

I wanted to retrieve 10 records at a time bcz it will return huge ResultSet.

How will be the query to retrieve the data with index range?

I appreciate ur help.

Thanks

If you only want to retrieve 10 rows, you can use the clause FETCH FIRST 10 ROWS ONLY. Is that what you meant?

No, i will pass first and last index ranges.
Let me put this way.
if my query can return 200 records, i should retrieve 50 records at a time instead of retrieving all the 200 records at a time.

This will help me if my query has chances to return 100,000 records.
So in that scenario, my application performance drastically come down.
So to aviod that first i will get only first 50 records first and show it, when user clicks next button i will get next 50 records from DB and display and so on.

I guess you might have understood my requirement.

Thanks

may we can do it using explicit cursor. I need help in this direction.

Thanks

Search for the words Pagination and/or Naveen in

www7b.boulder.ibm.com/dmdd

HTH

Sathyaram

Satyaram,
It's useful information for me. I appreciate it. It's nice link. This is what i am looking for.

Thanks