HPE NonStop SQL/MX Error – 4049 A CASE expression cannot have a result data type of both type1 and type2.

In this blog post, let’s learn about the error message “4049 A CASE expression cannot have a result data type of both type1 and type2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4049 A CASE expression cannot have a result data type of both type1 and type2.

Reason for the Error

You specified a CASE expression with a result data type of two data types. It must be have only one data type.

Solution

Correct the syntax and resubmit