HPE NonStop SQL/MX Error – 4209 Update of nullable column name is not permitted on rollback.

In this blog post, let’s learn about the error message “4209 Update of nullable column name is not permitted on rollback.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4209 Update of nullable column name is not permitted on rollback.

Reason for the Error

You attempted to perform a rollback that included an update of a nullable column.

Solution

Modify the statement and resubmit