Constraint violations

When the onpload utility starts a deluxe-mode load, it runs the following SQL statement:
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 HCL Informix® Guide to SQL: Syntax.

Copyright© 2019 HCL Technologies Limited