In this post, you’ll learn about the error message -407 an update or insert value is null, but the object column column-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
-407 an update or insert value is null, but the object column column-name cannot contain null values
Reason for the Error
The update or insert value was NULL, but the object column was declared as NOT NULL in the table definition. Consequently: *�� Null values cannot be inserted into that column. *�� Values in that column cannot be set to NULL by an update.
Solution
Examine the definition of the object table to determine which columns of the table have the NOT NULL attribute, and correct the SQL statement accordingly.
