In this blog post, let’s learn about the error message “4334 KEY_RANGE_COMPARE is not allowed on views.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4334 KEY_RANGE_COMPARE is not allowed on views.
Reason for the Error
KEY_RANGE_COMPARE function cannot be used on views.
Solution
Use KEY_RANGE_COMPARE function on tables or indexes