Monday, 26 May 2014

How to create a view without dirty reads

How to create a view without dirty reads

use the option "with no row movement" to create views dirty reads

Example how to create a view without dirty reads:

db2 create view teste_view as "select EMPNO from employee where FIRSTNME='MICHAEL' WITH NO ROW MOVEMENT"

No comments:

Post a Comment