When retrieving information from SAP system, in certain cases, we get results in hundreds or thousands. In such cases, if we want to implement a kind of pagination mechanism, what are the options available in JCO3.
First of all, how to restrict the records to a desired number (100 or 1000, etc)? Where should we define this?
How to continue to the next iteration of results with a limited records in each iteration/page?
That depends on the BAPI / function module you're using. If the BAPI supports pagination, fine - if it doesn't, the JCo won't be able to help you out. You'll have to retrieve all records and do the pagination in your application.