Patent ID: 6643637
Filing Date: 2003-11-04
Classification: G06F,Y10S

Abstract:
A method for making data available to an application program, comprising:generating a result table including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause, wherein the result table includes, for each row, a location identifier of the corresponding row in the base table; maintaining a cursor row pointer that points to a current row in the result table; receiving a fetch request from the application program to reposition the cursor row pointer to a target row in the result table that is different than the current row and return the data at the target row to the application program; repositioning the cursor row pointer to point to the target row in the result table; determining whether a delete flag for the target row indicates whether the corresponding row in the base table was deleted, wherein the target row in the result table is no longer available to return in response to the fetch request if the delete flag indicates that the corresponding row in the base table was deleted; and returning a code to the application program in response to the fetch request indicating that the requested row in the result table is not available.