[原创]db2 重要概念点(陆续更新) in 2016/1/30

db2inst1:/dbhome/db2inst1$db2 "create table emp_summary as (select e.empno, e.firstnme, e.lastname, e.phoneno, d.deptno, substr(d.deptname, 1, 12) as department, d.mgrno from employee e, department d where e.workdept=d.deptno) data initially deferred refresh immediate"
db2inst1:/dbhome/db2inst1$ db2 "set integrity for emp_summary immediate checked not incremental"