HPE NonStop SQL/MX Error – 4035 Type specification1 cannot be cast to type specification2.

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

Error Message

4035 Type specification1 cannot be cast to type specification2.

Reason for the Error

You attempted to cast type specification1 to another type specification2 that is not valid.

Solution

Correct the syntax and resubmit