Skip to Content
0
Former Member
Nov 22, 2006 at 02:29 AM

how to select records from a DB table using index?

483 Views

i have a problem of how to select records(for only one field)from DB table based on user's input on the selection screen,the detail is given below:

scenario 1: the spawn program will only select several key fields from VBREVK according to the user input. Every time select around x entries and kick off the batch job for these x entries. Then next x entries… I think this could be done by retrieve first x entries and keep track of the largest document number. Next time when retrieving data from VBREVK, add this document number to the selection criteria to find next x entries

scenario 2: select by index number in the table. If only selecting say 4 million records then selecting the records at index 1 and index 4 million based on the criteria would return our range. i only want to select 1 record for low value and 1 record for high value rather than selecting a whole tables worth of data.

usually we often select records into a internal table and the range is whole, i donn't know how to implement this using index, can anybody help me? thanks in advance.