Nonstop Database, HiRDB Version 9 UAP Development Guide
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
3.4.9 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
![[Figure]](FIGURE/ZU030408.GIF)
(b) DELETE statement that does not use a cursor or UPDATE statement to search for data matching a condition
![[Figure]](FIGURE/ZU030409.GIF)
(c) DELETE statement that uses a cursor
![[Figure]](FIGURE/ZU030410.GIF)
(d) UPDATE statement that uses a cursor
![[Figure]](FIGURE/ZU030411.GIF)
(e) SELECT or FETCH statement
![[Figure]](FIGURE/ZU030412.GIF)
![[Figure]](FIGURE/ZU03041A.GIF)
![[Figure]](FIGURE/ZU030413.GIF)
(2) Lock sequence of data manipulation SQL statements when non-locking of index key values is used
(a) INSERT statement
![[Figure]](FIGURE/ZU030415.GIF)
(b) DELETE statement that does not use a cursor or UPDATE statement to search for data matching a condition
![[Figure]](FIGURE/ZU030416.GIF)
(c) DELETE statement that uses a cursor
![[Figure]](FIGURE/ZU030417.GIF)
(d) UPDATE statement that uses a cursor
![[Figure]](FIGURE/ZU030418.GIF)
(e) SELECT or FETCH statement
![[Figure]](FIGURE/ZU030419.GIF)
![[Figure]](FIGURE/ZU030420.GIF)
(3) Order of locking uncommitted data to be deleted
(a) Searching for the data that satisfies a condition by using the DELETE or UPDATE statement
![[Figure]](FIGURE/ZU030421.GIF)
(b) For SELECT or FETCH statement
![[Figure]](FIGURE/ZU030422.GIF)
![[Figure]](FIGURE/ZU030423.GIF)
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.