In this blog post, let’s learn about the error message “4362 Using ASC/DESC with sequence functions is not supported.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4362 Using ASC/DESC with sequence functions is not supported.
Reason for the Error
ASC/DESC was specified in the expression of the RANK sequence function.
Solution
Rewrite the query so that it does not contain ASC/DESC in the argument of the RANK sequence function