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-11
SQL 1041
Cause. You attempted to add a primary key to a table that already has a primary key.
Effect. The operation fails.
Recovery. None.
SQL 1042
Cause. You did not specify NOT NULL on one or more columns that are included in a
UNIQUE or PRIMARY KEY constraint.
Effect. The operation fails.
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.
1041 The primary key has already been defined.
1042 All PRIMARY KEY or UNIQUE constraint columns must be NOT
NULL.
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.