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-78
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.
Recovery. None.
SQL 1615
Where constrainttype is the type of constraint, NOT NULL or primary key.
Where referentialaction is the referential action.
Cause. The NOT NULL constraint cannot be created on a referencing column with the
SET NULL referential action on it. (OR) The primary key constraint cannot be created
on the referencing column with the referential action specified because the primary key
cannot be updated.
Effect. The operation fails.
Recovery. Drop the referential integrity constraint.
SQL 1616
Where reason can be nested views or a view with VALUES constructor.
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.
1615 constrainttype cannot be created, since it conflicts
with referentialaction referential action of the referential
constraint ConstraintName.
1616 Similarity Check is not supported for reason.