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-30
Effect. The operation fails.
Recovery. Specify a different schema and resubmit.
SQL 1119
Where table-name is the name of an SQL/MX metadata table.
Cause. You attempted to use the DROP TABLE statement to drop a table that is part
of SQL/MX metadata.
Effect. The table is not dropped.
Recovery. Metadata tables can be dropped only by using the DROP SQL statement
or the MXTOOL GOAWAY utility. Both methods will irrevocably destroy the database.
SQL 1120
Cause. You attempted an operation on a partitionable table that has float datatype in
the partitioning key.
Effect. The operation fails.
Recovery. None. Contact your service provider.
SQL 1121
Where table-name is the name of the table.
Cause. You attempted to do an invalid ADD, DROP, or MODIFY of a partition.
Effect. The operation fails.
Recovery. None.
1119 Dropping metadata object table-name is not allowed.
1120 Use of float datatype in a partitioning key is not
allowed.
1121 Partitions cannot be added or dropped on table table-
name. These partition operations are not allowed on tables
whose clustering key consists only of the SYSKEY.