HPE NonStop SQL/MX Error – 4134 The operation (name) is not allowed. Try UNION ALL instead.

In this blog post, let’s learn about the error message “4134 The operation (name) is not allowed. Try UNION ALL instead.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4134 The operation (name) is not allowed. Try UNION ALL instead.

Reason for the Error

You attempted to perform an operation that NonStop SQL/MX does not allow.

Solution

Try a UNION ALL operation and resubmit