When you issue a START VIOLATIONS TABLE statement for a target table, the diagnostics table that the statement creates has a predefined structure. This structure is independent of the structure of the target table.
The following table shows the schema of the diagnostics table.
| Column Name | Data Type | Description | ||
|---|---|---|---|---|
| informix_tupleid | INTEGER | Implicitly refers to informix_tupleid column values in the violations table This relationship, however, is not declared as a foreign-key to primary-key relationship. | ||
| objtype | CHAR(1) | Identifies the type of violation This column can have the following values: | ||
| C = | Constraint violation | |||
| I = | Unique-index violation | |||
| objowner | CHAR(32) | Identifies the owner of the constraint or index for which an integrity violation was detected | ||
| objname | VARCHAR(128, 0) | Contains the name of the constraint or index for which an integrity violation was detected | ||