In this blog post, let’s learn about the error message “3163 Host variable name appears more than once in the INTO list. Execution results will be undefined.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3163 Host variable name appears more than once in the INTO list. Execution results will be undefined.
Reason for the Error
You specified an INSERT statement whose INTO list includes host variable name more than once.
Solution
This is an informational message only. No corrective action is needed, but you might want to rewrite your query