In this post, you’ll learn about the error message -151 the update statement is invalid because the catalog description of column column-name indicates that it cannot be updated in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-151 the update statement is invalid because the catalog description of column column-name indicates that it cannot be updated
Reason for the Error
The specified column cannot be updated due to one of the following:� *�� The object table is partitioned (that is, resides in a partitioned���� table space) and the column is included in the partitioning key.� *�� The object table is a view and the specified column is defined (in the���� definition of the view) in such a way that it cannot be updated.� *�� The object table is a catalog table.� The values for columns occurring in the partitioning key of a partitioned table cannot be updated.� Individual columns in a view cannot be updated for one of the following reasons:� *�� The column is derived from an SQL function, an arithmetic expression,���� or a constant.� *�� The column is defined for a column that is in the partitioning key of���� a partitioned table.� *�� The column is defined for a column of an underlying view that cannot���� be updated.
Solution
The requested function is not supported by DB2.
