There's 4 isolation levels in db2.
- uncommitted read (UR)
- cursor stability (CS)
- read stability (RS)
- repeatable read (RR)
example:
SELECT * FROM TEST
WITH UR
DECLARE mycur CURSOR FOR
SELECT * FROM TEST
WITH UR
Can't specify isolation in the ddl of a view.
The following syntax is also supported:
- UR - READ UNCOMMITTED
- UR - DIRTY READ
- CS - READ COMMITED
- CS - CURSOR STABILITY
- RR - REPEATABLE READ
- RR - SERIALIZABLE
- 文章信息
- 版权声明: 本文可以任意转载，转载时请务必以超链接形式标明文章原始出处和作者信息。
- 原文出处: http://www.aiview.com/
- 写于: 2006-02-24 [Edit]
- 作者: Alex (email &msn)
- 标签 Tags: DB2 Development (24)
