In this blog post, let’s learn about the error message “3199 Column col-name is incorrectly specified. Keywords ASCENDING and DESCENDING are not allowed in the partitioning key list.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3199 Column col-name is incorrectly specified. Keywords ASCENDING and DESCENDING are not allowed in the partitioning key list.
Reason for the Error
You cannot specify ordering for columns of a partitioning key clause.
Solution
Remove any of the following keywords from the columns specified in the PARTITION clause: ASCENDING, ASC, DESCENDING, DESC, and resubmit