Home > Term: update hole
update hole
(1) A row for a SELECT statement of a cursor that no longer has a corresponding row in the base table because the row was updated. An update hole is created when a row in the base table is updated such that the row no longer qualifies to be in the result set while a cursor is open whose SELECT statement result contains the row that is updated. Such a row is no longer accessible though the cursor. See also delete hole.
(2) The location on which a cursor is positioned when a row in a result table is fetched again and the new values no longer satisfy the search condition. See also delete hole.
- Part of Speech: noun
- Industry/Domain: Software
- Category: Globalization software service
- Company: IBM
0
Creator
- PWH617
- 100% positive feedback