HPE NonStop SQL/MX Error – 4112 Absolute and relative sampling cannot occur in the same BALANCE expression.

In this blog post, let’s learn about the error message “4112 Absolute and relative sampling cannot occur in the same BALANCE expression.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4112 Absolute and relative sampling cannot occur in the same BALANCE expression.

Reason for the Error

You attempted to perform absolute and relative sampling in the same balance expression, which is not supported.

Solution

Correct the syntax and resubmit