SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
3-78
SQL 1611
Cause. You attempted to create a referential integrity constraint with the SET
DEFAULT clause for a column that was defined without a DEFAULT value.
Effect. The operation fails.
Recovery. Remove the SET DEFAULT clause in the referential integrity constraint or
set a DEFAULT value for the column on which you want to create the referential
integrity constraint.
SQL 1612
Cause. You attempted to create a column list and the referential actions of a
referential integrity constraint, which matches the column list and referential action of
another referential integrity constraint in the table.
Effect. The operation fails.
Recovery. None.
SQL 1613
Cause. You attempted to create a column list of referential integrity constraint, which
matches the column list of another referential integrity constraint in the table. However,
the referential action differs for these two constraints.
Effect. The operation fails.
Recovery. None.
SQL 1614
Cause. You attempted to create a referential integrity constraint with a referencing
column that is a part of the clustering key of the referencing table.
Effect. The operation fails.
1611 SET DEFAULT clause cannot be applied to column
$0~ColumnName which has a NO DEFAULT clause.
1612 Constraint constraintName could not be created as it is
a duplicate of constraintName.
1613 Constraint constraintName could not be created as it
conflicts with constraintName.
1614 Constraint constraintName could not be created as
referencing column columnName is part of clustering key of
table tableName.