SQL/MX 3.1 Messages Manual (H06.23+, J06.12+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.1 Messages Manual—663849-001
3-11
SQL 1040
Cause. An ALTER TABLE statement was issued naming a table that is part of the
SQL/MX metadata. Such tables cannot be altered.
Effect. The operation fails.
Recovery. None.
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.
1040 The use of ALTER on metdata tables is not permitted.
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.