![HP Neoview Messages Manual Download Page 32](http://html.mh-extra.com/html/hp/neoview-messages/neoview-messages_manual_165138032.webp)
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)
Summary of Contents for Neoview Messages
Page 12: ...12 ...
Page 66: ...66 ...
Page 129: ...Recovery Supply the input values for the IDENTITY column 129 ...
Page 130: ...130 ...
Page 172: ...172 ...
Page 178: ...178 ...
Page 184: ...184 ...
Page 238: ...238 ...
Page 266: ...266 ...
Page 268: ...268 ...
Page 350: ...350 ...
Page 378: ...378 ...
Page 384: ...384 ...
Page 400: ......