logo  
Google
 

DB2 SQL-Error: -151

SQLState: 42808

Short Description: THE UPDATE STATEMENT IS INVALID BECAUSE THE CATALOG DESCRIPTION OF COLUMN INDICATES THAT IT CANNOT BE UPDATED

The specified column cannot be updated for one of the following reasons: v The values for columns occurring in the partitioning key of a partitioned table cannot be updated. v 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. v The object table is a catalog table with no columns that can be updated. v The object column is a ROWID column. v The object column is defined with the AS IDENTITY and GENERATED ALWAYS attributes. v The specified column of catalog tables cannot be updated because the column itself is not updatable. Individual columns in a view cannot be updated for one of the following reasons: v The column is derived from an SQL function, an arithmetic expression, or a constant. v The column is defined for a column of an underlying view that cannot be updated. v The column is defined for a read-only view. v The column is defined for a column that is in the partitioning key of a partitioned table.System action: The statement cannot be executed. No data was updated in the object table or view. Programmer response: The requested function is not supported by DB2. Refer to the description of the UPDATE statement in Chapter 5 of DB2 SQL Reference for information about restrictions on the ability to update ROWID columns, identity columns, and columns in partitioned tables and views.

 <-  BACK TO INDEX