HPE NonStop SQL/MX Error – 4313 Function rand()is not supported.

In this blog post, let’s learn about the error message “4313 Function rand()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

4313 Function rand()is not supported.

Reason for the Error

You attempted to use the random function, which is not supported.

Solution

Correct the syntax and resubmit