In this blog post, let’s learn about the error message “2213 A syntax error was encountered: expecting an identifier instead of string.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
2213 A syntax error was encountered: expecting an identifier instead of string.
Reason for the Error
You invoked mxCompileUserModule on an application file, possibly 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 an identifier is expected. Verify that the list of module names are specified correctly and retry the command
