-
1.
公开(公告)号:US06665678B2
公开(公告)日:2003-12-16
申请号:US09750543
申请日:2000-12-28
IPC分类号: G06F1730
CPC分类号: G06F17/30595 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99938 , Y10S707/99942 , Y10S707/99943 , Y10S707/99953
摘要: Provided is a method, system, and program for performing a cursor operation. A result table is generated 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. A command is received to perform a cursor operation with respect to a subject row in the result table. A lock is obtained on a row in the base table corresponding to the subject row in the result table. An operation specified in the received command is performed with respect to the subject row after obtaining the lock. The lock on the row in the base table is released after performing the operation.