Neoview Messages Manual (Volume 1) (R2.4)

Cause The MODIFY utility could not create the target partition because the specified volume
in the LOCATION clause does not exist.
Effect The MODIFY utility did not process the request.
Recovery None.
SQL 1116
1116 The current partitioning scheme requires a user-specified clustering
key on object table-name.
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
1117 Dropping the only partition of an object is not allowed. At least
two partitions must exist to perform the drop.
Cause You attempted to drop the only partition of the object.
Effect The operation fails.
Recovery None.
SQL 1118
1118 Creating object table-name is not allowed in metadata schema.
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
1119 Dropping metadata object table-name is not allowed.
table-name
is the name of an HP Neoview database metadata table.
Cause You attempted to use the DROP TABLE statement to drop a table that is part of the
HP Neoview database 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
1120 Use of float datatype in a partitioning key is not allowed.
Cause You attempted an operation on a partitionable table that has float data type in the
partitioning key.
Effect The operation fails.
Recovery Modify so the partitioning key does not contain a float column and resubmit.
32 Data Definition Language (DDL) Messages (1000 Through 1999)