SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Privilege and Alias Messages (1000 through 1999)
HP NonStop SQL/MX Messages Manual—523730-004
3-35
Recovery. None. Contact your service provider.
SQL 1143
Where constraint-name is the name of a column constraint or table constraint.
Where referencing-table-name is the table on which the constraint is being
added.
Where referenced-table-name is the table specified in the FOREIGN KEY
clause.
Where statement-text is a query.
Cause. You attempted to add a referential integrity constraint that is violated by rows
already in the table.
Effect. The operation fails.
Recovery. Run the query statement-text to see the rows that violate the
referential constraint. Either change those rows or change the referential constraint
definition and resubmit.
SQL 1144
Where column-name is the column in table-name.
Where table-name is the name of the table.
Where first-key-string is the erroneous value used in the FIRST KEY clause for
column-name.
Cause. In a CREATE TABLE statement, a value specified as first key is not a quoted
string, but the type of the column for which this value is specified is one of the
character data types.
Effect. The operation fails.
Recovery. Correct the value first-key-string to be a type that is compatible with
the type of column column-name and resubmit.
1143 Validation for constraint constraint-name failed;
incompatible data exists in referencing base table
referencing-table-name and referenced base table referenced-
table-name. To display the data violating the constraint,
please use the following DML statement: statement-text.
1144 A quoted string was expected in first key clause for
column column-name on table table-name, but the value
detected is (first-key-string).