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-23
SQL 1094
Where object-name is the ANSI name of the object stated in the DROP command.
Where object-type is the type of object that was stated in the DROP command.
Cause. A DROP TABLE specified an object that is not a base table, or a DROP VIEW
specified an object that is not a view, or a DROP PROCEDURE specified an object
that is not a procedure.
Effect. The operation fails.
Recovery. Reissue the DROP statement with the correct combination of specified
object type and actual object type.
SQL 1095
Where column-name is the name of a column of the specified table.
Cause. This error is reported if a column specified in the partitioning key of the
“PARTITION BY (<partitioning_columns>)” clause of a CREATE TABLE or CREATE
INDEX statement is not also a member of the clustering key.
Effect. The table or index is not created.
Recovery. Either remove the offending column from the partitioning key specification
(and possibly replace it with a column that is a member of the clustering key) or add
the offending column to the clustering key by using the STORE BY clause or by adding
it to the primary key.
SQL 1098
Where key is a partition key.
Where object-name is the name of the table being created or changed.
Cause. You attempted to create or change a table so that more than one partition has
the same first key.
Effect. The operation fails.
1094 Object object-name could not be dropped because it is
not of type object-type.
1095 The PARTITION BY column column-name should also be part
of the clustering/storage key.
1098 Duplicate partition key (key)specified for object
object-name.