SQL/MX 3.2.1 Messages Manual (H06.26+, J06.15+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.2.1 Messages Manual—691121-002
3-77
Recovery. Remove the NO SELECT syntax and resubmit the statement.
SQL 1610
Cause. You attempted to create a referential integrity constraint with the SET NULL
clause for a column, which was defined with the NOT NULL property.
Effect. The operation fails.
Recovery. Remove the SET NULL clause in the referential integrity constraint or drop
the NOT NULL constraint for the column on which you want to create the referential
integrity constraint.
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.
1610 SET NULL clause cannot be applied to column ColumnName
which has a NOT NULL constraint defined on it.
1611 SET DEFAULT clause cannot be applied to column
ColumnName which has a NO DEFAULT clause.
1612 Constraint new-constraint-name could not be created as
it is a duplicate of existing-constraint-name.