In this post, you’ll learn about the error message -408 an update or insert value is not comparable with the data type of its object column column-name in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-408 an update or insert value is not comparable with the data type of its object column column-name
Reason for the Error
The data type of the value to be inserted into or set in the column ‘column-name’ by an INSERT or UPDATE statement is incompatible with the declared data type of that column.� Both must be numeric or both must be graphic string; or both must be either: *�� Dates or character *�� Times or character *�� Timestamps or character. However, dates, times, or timestamps cannot be assigned to a character column that has a field procedure.
Solution
Examine the current definition for the object table, and ensure that the host variable or literal value assigned to the specified column has the proper data type.
