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-28
SQL 1116
Where table-name is the name of the table.
Cause. The partitioning scheme requires a user-specified clustering key.
Effect. The operation fails.
Recovery. Specify a clustering key, either through a PRIMARY KEY, STORE BY, or
PARTITION BY clause.
SQL 1117
Cause. You attempted to drop the only partition of the object.
Effect. The operation fails.
Recovery. None.
SQL 1118
Where table-name is the name of the object.
Cause. You attempted to create an object in the metadata schema.
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.
1116 The current partitioning scheme requires a user-
specified clustering key on object table-name.
1117 Dropping the only partition of an object is not allowed.
At least two partitions must exist to perform the drop.
1118 Creating object table-name is not allowed in metadata
schema.
1119 Dropping metadata object table-name is not allowed.