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-11
Recovery. Reissue the statement with NOT NULL specified for all columns that are in
the PRIMARY KEY and UNIQUE constraints.
SQL 1043
Where constraint-name is the name of a column constraint or table constraint.
Cause. You assigned the same constraint name to two constraints on the same table.
Constraint names must be unique among all the constraints for a table.
Effect. The operation fails.
Recovery. Make all the constraint names for the table unique. Use SHOWDDL to see
the names of existing constraints.
SQL 1044
Where constraint-name is the name of a column constraint or table constraint.
Cause. The columns that constraint-name references in the referenced table are
not part of a unique constraint.
Effect. The operation fails.
Recovery. Check that constraint-name references a unique or primary constraint
in the referenced table.
SQL 1045
Cause. The referential constraint is referencing the unique constraint that is declared
as deferrable. This is an internal error.
Effect. The operation fails.
Recovery. Check that the referential constraint references a unique constraint that is
not declared deferrable. Contact your service provider.
1043 Constraint constraint-name already exists.
1044 Constraint constraint-name could not be created because
the referenced columns in the referenced table are not part
of a unique constraint.
1045 The unique constraint cannot be used because it is
deferrable.