Select this radio button to specify that the table not be checked immediately for constraint violations when constraint checking is turned on.
When you select this radio button, you can use the Referential constraints and Check constraints check boxes to specify the constraint type for which you are turning on constraint checking. (Referential constraints are foreign keys).
When you turn on constraint checking without performing the checking, this fact is recorded in the database catalog (the value in the CONST_CHECKED column in the SYSCAT.TABLES view is set to 'U'). This value indicates that you have assumed responsibility (over the database management system) for ensuring the integrity of the data, with respect to the constraints turned on. This value remains the same until either:
[ Top of Page | Table of Contents | Glossary | Index ]