HP NonStop SQL/MX, Messages Manual

Page: 50 / 752

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Messages Manual — 640324-001
3- 24
Recovery. Remove the self-reference and resubmit.
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 Partition key ( key ) already specified for object object-
name .