Constraint Violations

When the onpload utility starts a deluxe-mode load, it invokes the following SQL statement:

SET CONSTRAINTS ON mytable FILTERING

This statement has two results:

• The utility adds two tables, mytable_vio and mytable_dia, to the database that contains mytable.
• All of the constraints that are associated with the table are set to filtering. Filtering mode causes any record that does not meet the constraint requirements to be added to the mytable_vio table instead of generating an error.

The use of filtering mode for constraints is covered in detail in the IBM Informix: Guide to SQL Syntax.