SQL/MX 2.x Messages Manual (H06.04+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Messages Manual—540498-003
3-30
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.
SQL 1123
Where key is a list of the partition key values.
Where object-name is the name of the object.
Cause. You attempted to access a table using a first key value that contains an
element that is not supported.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 1124
Cause. You attempted an operation on a partitionable table that has float datatype in
the partitioning key.
Effect. The operation completes without errors, but the results might not be correct.
The float data value might not be evaluated consistently to the same value each time.
Recovery. Do not use float datatypes in the partitioning key of a partitionable table.
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.
1123 Not all of the partition key values (key) for object
object-name could be processed. Please verify that the
correct key value data types were specified.
1124 Use of a float datatype in a partitioning key has been
enabled by the default
ALLOW_FLOAT_DATATYPES_IN_PARTIONING_KEY. This could give some
incorrect results and the users should be aware of it.