However, in some cases, you will need to read cursors both forward and backward, in which case you should use scrollable cursor.
但某些情况下,您需要游标既能向前又能向后,此时需要使用可滚动游标。
Another approach is to explicitly open the cursor again after ROLLBACK and skip the cursor pointer till the record read at the time of ROLLBACK.
另一种方法是在ROLLBACK之后再次显式地打开游标,然后在ROLLBACK时把游标指针跳到读取的记录。
Supports table and row level locking and 4 isolation levels, RR (repeatable read), rs (read stability), CS (default - cursor stability) and ur (uncommitted read).
支持表级和行级锁以及4个隔离级别:RR(可重复读)、RS(读可靠)、CS(默认——游标可靠)和UR(未提交读)。
The Virtual PC cursor mode lets users read through the document line by line or by using several shortcuts.
VirtualPC光标模式为用户逐行读取文档或使用快捷方式读取。
FOR read-only cursors, make the cursor unambiguous by using the FOR read only clause.
对于只读游标,使用FORREADONLY子句确保游标无歧义。
I've always thought that READ_COMMITTED (DB2 calls it Cursor Stability (CS)) meant that you do NOT lock on reads, and that you only read the committed data.
我一直认为read_committed (DB 2调用游标稳定性(CS))意味着你不锁上读,那你只能读提交的数据。
Release the row locks so that other applications can SELECT, INSERT, UPDATE, and DELETE from the table (for example, use isolation level cursor stability or uncommitted read).
释放行锁,以便其他应用程序可以对表执行SELECT、INSERT、UPDATE和DELETE(例如,使用游标稳定性(curs or stability)隔离级别或未提交读(uncommitted read)隔离级别)。
Release the row locks so that other applications can SELECT, INSERT, UPDATE, and DELETE from the table (for example, use isolation level cursor stability or uncommitted read).
释放行锁,以便其他应用程序可以对表执行SELECT、INSERT、UPDATE和DELETE(例如,使用游标稳定性(curs or stability)隔离级别或未提交读(uncommitted read)隔离级别)。
应用推荐