Example of a Violations Table
To start a violations and diagnostics table for the target table
named customer in the demonstration database, enter the following
statement:
START VIOLATIONS TABLE FOR customer;
Because you include no USING clause, the violations table is named customer_vio by default. The customer_vio table includes these five columns:
| Column One | Column Two | Column Three | Column Four | Column Five |
|---|---|---|---|---|
| customer_num fname lname | company address1 address2 | city state | zipcode phone | informix_tupleid informix_optype informix_recowner |
The customer_vio table has the same table definition as the customer table except that the customer_vio table has three additional columns that contain information about the operation that caused the nonconforming row.