Select records in Batches from DB.
We have a requirement to pull records from DBCS. The data/volume is very high and its required to pick records in batches. Example we have 200K rows of data in a table and its required to only pull 5K at once. Is there is way this can be achieved in OIC using DB Adapter.