In this blog post, let’s learn about the error message “1610 SET NULL clause cannot be applied to column ColumnName which has a NOT NULL constraint defined on it.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1610 SET NULL clause cannot be applied to column ColumnName which has a NOT NULL constraint defined on it.
Reason for the Error
You attempted to create a referential integrity constraint with the SET NULL clause for a column, which was defined with the NOT NULL property.
Solution
Remove the SET NULL clause in the referential integrity constraint or drop the NOT NULL constraint for the column on which you want to create the referential integrity constraint
