Patent ID: 7743333

Claim:
A computer implemented method for suspending a result set for scrollable cursors, comprising: receiving a request for data in an original result set which is generated in response to the request or to a query, wherein the original result set in a first computer readable storage medium is maintained by a first scrollable cursor state on a side of a server and a second scrollable cursor state on a side of a client; suspending, by using a processor, the data from the original result set by copying the original result set to a second computer readable storage medium to allow the client to access, from the result set that is being suspended, the same data or same order of the data of the original result set without re-issuing or re-executing the query or a new query, wherein, the result set that is being suspended allows the data of the original result set to be accessible by the client without retaining the first scrollable cursor state on the side of the server when the original result set is no longer available to the client, and the client is allowed to access the same data or the same order of the data of the original result set from the result set that is being suspended without re-issuing or re-executing the query or the new query while ensuring correctness in accessing the data; fetching the data from the original result set or from the data set that is being suspended; and displaying a result of the act of fetching the data on a display apparatus or storing the result of the act of fetching the data in a tangible computer usable storage medium, the first computer readable storage medium, the second computer readable medium, or a storage device.