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-10
SQL 1038
Cause. You attempted to drop SQL while one or more user-created catalogs existed.
Effect. The operation fails.
Recovery. You must drop all user-created catalogs before dropping SQL.
SQL 1039
Cause. See the accompanying error message for the cause.
Effect. SQL/MX does not drop SQL.
Recovery. Apply the recovery of the accompanying error message.
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.
1038 Not all user catalogs have been dropped from the system.
1039 The DROP SQL statement could not be executed.
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.