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.
USING Clause

USING Clause

You can use the USING clause to declare explicit names for the violations table and for the diagnostics table.

If you omit the USING clause, the database server assigns names to the violation table and the diagnostics table. The system-assigned name of the violations table consists of the name of the target table followed by the string _vio. The name that the database server assigns to the diagnostics table consists of the name of the target table followed by the string _dia.

If you omit the USING clause, the maximum length of the name of the target table is 124 bytes.