HPE NonStop SQL/MX Error – 1120 Use of float datatype in a partitioning key is not allowed.

In this blog post, let’s learn about the error message “1120 Use of float datatype in a partitioning key is not allowed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1120 Use of float datatype in a partitioning key is not allowed.

Reason for the Error

You attempted an operation on a partitionable table that has float datatype in the partitioning key.

Solution

None. Contact your service provider