如果对目标表定义了冲突,冲突表与诊断表将保留没有满足约束的行。
If the target table has violations defined, the violation table and diagnostic table hold the non-conforming rows that fail to satisfy constraints.
checks为每个表检查约束保持一个行db2 select constname, tabname, text from syscat . checks。
Syscat.checks Contains a row for each table check constraint db2 select constname, tabname, text from syscat.checks.
第22行到28行为每周的每天定义了一个约束。
Lines 22 through 28 define one constraint for each day of the week.
应用推荐