Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
START VIOLATIONS TABLE statementUse the START VIOLATIONS TABLE statement to create a violations table and a diagnostics table for a specified target table. The START VIOLATIONS TABLE statement is an extension to the ANSI/ISO standard for SQL.
Structure of the diagnostics tableWhen 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.

Structure of the diagnostics table

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