HPE NonStop SQL/MX Error – 4127 Type name1 cannot be assigned to type name2.

In this blog post, let’s learn about the error message “4127 Type name1 cannot be assigned to type name2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4127 Type name1 cannot be assigned to type name2.

Reason for the Error

You attempted to perform an assignment but specified incompatible data types.

Solution

Correct the syntax and resubmit