If informational check constraints exist on the primary key column, you should explicitly specify informational check constraints on their corresponding foreign key columns. For example.
如果在主键列上存在信息检查约束，那么应该在它们相应的外键列上指定信息检查约束。
You can also use the system catalog views to retrieve information about NOT NULL, unique, primary key, foreign key, and table check constraints. For example.
也可以使用系统编目视图来检索关于NOT NULL、惟一、主键、外键和表检查约束的信息。
Syscat.tabconst Contains a row for each unique (u), primary key (p), foreign key (f), or table check (k) constraint db2 select constname, tabname, type from syscat.tabconst.
tabconst为每个唯一性(U)、主键(p)、外键(f)或者表检查(K)约束保持一个行db2select constname,tabname,typefrom syscat . tabconst。
Minimize the triggers, CHECK and foreign key constraints, and generated columns for the table.
尽量减少表上的触发器、检查和外键约束以及生成的列。
This category of overhead includes CHECK constraint verification and foreign key constraint (referential integrity (ri)) verification.
这一类的开销包括检查约束验证和外键约束(参照完整性(RI))验证。
For example, if there are any dependent tables (tables that have a foreign key referencing the table into which data is to be loaded, for example), they might be placed in the CHECK PENDING state.
例如，如果存在依赖表(例如表中有一个外键，该外键引用数据要被装载到的目标表)，那么这些表可能被设为CHECK PENDING状态。
For example, if there are any dependent tables (tables that have a foreign key referencing the table into which data is to be loaded, for example), they might be placed in the CHECK PENDING state.
例如，如果存在依赖表(例如表中有一个外键，该外键引用数据要被装载到的目标表)，那么这些表可能被设为CHECK PENDING状态。
应用推荐