In this post, you’ll learn about the error message -629 set null cannot be specified because foreign key name cannot contain null values in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-629 set null cannot be specified because foreign key name cannot contain null values
Reason for the Error
The code is used to report that the SET NULL option of the indicated FOREIGN KEY clause is invalid because no column of the key allows null values.� The ‘name’ is the constraint name specified in the FOREIGN KEY clause or, if a constraint name was not specified, the first column name specified in the clause.
Solution
Change a column of the key to allow null values or change the delete rule.
