In this blog post, let’s learn about the error message “3023 The COLLATE clause in a sort specification is not yet supported.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3023 The COLLATE clause in a sort specification is not yet supported.
Reason for the Error
You attempted to perform a COLLATE clause in a sort specification, which is not supported.
Solution
Remove the COLLATE clause and resubmit