In this blog post, let’s learn about the error message “The [FIRST/ANY n] syntax is not allowed in query expression of a view.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
The [FIRST/ANY n] syntax is not allowed in query expression of a view.
Reason for the Error
An internal error occurred during retrieval of node numbers in SQL/MX cluster.
Solution
See the Operator Messages Manual for information on EMS event messages
