In this blog post, let’s learn about the error message “4094 The number of output host variables (value1) must equal the number of selected values (value2).” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4094 The number of output host variables (value1) must equal the number of selected values (value2).
Reason for the Error
NonStop SQL/MX requires that the number of output host variables, value1, match the number of selected values, value2.
Solution
Correct the syntax and resubmit