Scalable Database Server, HiRDB Version 8 UAP Development Guide
3.4.8 Lock sequence based on SQL statement and index types
(1) Lock sequence of data manipulation SQL statements for index key values and data page rows
(a) INSERT statement
(b) DELETE statement that does not use a cursor or UPDATE statement to search for data matching a condition
(c) DELETE statement that uses a cursor
(d) UPDATE statement that uses a cursor
(e) SELECT or FETCH statement
(2) Lock sequence of data manipulation SQL statements when non-locking of index key values is used
(a) INSERT statement
(b) DELETE statement that does not use a cursor or UPDATE statement to search for data matching a condition
(c) DELETE statement that uses a cursor
(d) UPDATE statement that uses a cursor
(e) SELECT or FETCH statement
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.