12.20.4 Data manipulation and integrity

When a check constraint table is updated, added to, or deleted by a data manipulation SQL statement, HiRDB performs checking during execution to guarantee data integrity. However, if the table is manipulated by the utilities listed in the following table, data integrity may not be guaranteed because HiRDB does not perform integrity checking. If you specify USE in the pd_check_pending operand and perform these operations, the check constraint table is placed in check pending status.

Table 12-25 Operations on check constraint tables that nullify the guarantee of data integrity and the conditions under which loss of data integrity occurs

Operation on table or RDAREACondition for loss of data integrity
Database load utility (pdload)Data reloadData that does not satisfy search conditions specified in the check constraint definition is loaded.
Data that does not satisfy search conditions specified in the check constraint definition is reloaded.
Database reorganization utility (pdrorg)Reload (-k reld)