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-29
SQL 1120
Cause. You attempted an operation on a partitionable table that has float datatype in
the partitioning key.
Effect. The operation fails.
Recovery. Enable the default
ALLOW_FLOAT_DATATYPES_IN_PARTITIONING_KEY via a control query default
statement and retry the operation.
SQL 1121
Where table-name is the name of the table.
Cause. You attempted to do an invalid ADD, DROP, or MODIFY of a partition.
Effect. The operation fails.
Recovery. None.
SQL 1122
Where partition-key-value-list is a list of the partition key values.
Where object-name is the name of the object.
Where key-col-number is the number of columns in the user-defined key.
Cause. The number of specified partition key values (partition-key-value-
list) for object object-name exceeds the number of user-defined key columns,
key-col-number.
Effect. The operation fails.
Recovery. Fix the statement and resubmit.
1120 Use of float datatype is a partitioning key is not
allowed.
1121 Partitions cannot be added or dropped on table table-
name. These partition operations are not allowed on tables
whose clustering key consists only of the SYSKEY.
1122 The number of specified partition key values (partition-
key-value-list) for object object-name exceeds the number of
user defined key columns, key-col-number.