In this blog post, let’s learn about the error message “2212 A syntax error was encountered: expecting string1 instead of string2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
2212 A syntax error was encountered: expecting string1 instead of string2.
Reason for the Error
You invoked mxCompileUserModule on an application file, intending to SQL compile only a subset of its embedded module definitions, but you specified an unexpected string in the module name list.
Solution
Review the module name list syntax, especially where string1 is expected. Verify that the list of module names are specified correctly and retry the command
