In this blog post, let’s learn about the error message “3164 There is a data type mismatch between output host variable and selected value.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3164 There is a data type mismatch between output host variable and selected value.
Reason for the Error
A data type mismatch occurred between the output host variable and the selected value in the statement you specified.
Solution
Correct the syntax and resubmit