Personal tools
You are here: Home → DB2 → How To's → How to create a view without dirty reads
Navigation
Log in


Forgot your password?
 
Document Actions

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"
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls