METHOD, SYSTEM, AND PROGRAM FOR SCROLLING INDEX SCANS

Provided is a method, system and program for accessing records in a database object, such as an index or table. A cursor is maintained that points to a start ent ry in the database object. The database object has rows and columns of values. A runtime component receives a command to return a kth entry in the object having column values that satisf y predicates in a query statement. The runtime component calls a manager component that access es entries in the database object to return the kth entry in the object having column values that satisfy the predicates. The manager component moves the cursor through sequential entrie s in the database object, in either the forward or reverse direction, until a kth entry that satisfies the predicates from the start entry is reached. The manager component positions the cursor to an entry that is the kth entry that satisfies the predicates from the start entry and returns data from the kth entry pointed to by the cursor to the runtime component.