HPE NonStop SQL/MX Error – 4184 Columns that are part of a referential constraint cannot be updated using embedded UPDATE statements.

In this blog post, let’s learn about the error message “4184 Columns that are part of a referential constraint cannot be updated using embedded UPDATE statements.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4184 Columns that are part of a referential constraint cannot be updated using embedded UPDATE statements.

Reason for the Error

You attempted to perform an embedded UPDATE statement on columns that are part of a referential constraint.

Solution

Modify the statement and resubmit