for particular data if there are more than 500 records in table then at single point of time <= 500 recs will be fetched and displayed on web.
e.g. if there are 1400 records, then during first call of SP, first 500 i.e. 1st to 500th records will be displayed. at this time NEXT link on web will be enabled and when user clicks NEXT , 501th to 1000th records should be fetched and displayed. at this time both PREV and NEXT links will be enabled. if user clicks NEXt then 1001th to 1400th records should be displayed. if user Clicks PREV then in first PREV 501th to 1000th records should again fetched and displayed and in second PREV click 1st to 500th records should be diplayed.
To fulfil this, I wanted to know if we can calculate and maintain row position , and setting the upper and lower limit of this row position can we fetch data in DB2 cursor ?
Please help on this or any other suggestion/reference will be highly appreciated.