In this blog post, let’s learn about the error message “2220 mxcmp path (MXCMP environment variable) does not exist or is not executable.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
2220 mxcmp path (MXCMP environment variable) does not exist or is not executable.
Reason for the Error
You set your MXCMP environment variable to point to your own MXCMP and invoked mxCompileUserModule on an application file to SQL compile its module definitions. Your MXCMP is not executable.
Solution
Verify that your MXCMP exists and is executable and retry the command