In this blog post, let’s learn about the error message “2201 SQL compilation return code is mxcmp non-zero exit code.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
2201 SQL compilation return code is mxcmp non-zero exit code.
Reason for the Error
You invoked mxCompileUserModule on an application file that has an embedded module definition. An SQL compilation of an embedded module definition resulted in an MXCMP nonzero exit code, indicating a warning or error.
Solution
Review the MXCMP warning or error message. Trace the diagnostic back to the module source file and correct the offending source statement. Retry preprocessing, translating, compiling, and SQL compiling the application file
