|
A declaração UPDATE é inválida porque no catálogo de descrição de colunas
column-name indica que a mesma não pode ser alterada.
Conclusão: The specified column cannot be updated for one of the
following reasons:
- The values for columns occurring in the partitioning key of a partitioned table cannot be updated.
- 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 with no columns that can be updated.
- The object column is a ROWID column.
- The object column is defined with the AS IDENTITY and GENERATED ALWAYS attributes.
- 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:
- The column is derived from an SQL function, an arithmetic expression, or a constant.
- The column is defined for a column of an underlying view that cannot be updated.
- The column is defined for a read-only view.
- The column is defined for a column that is in the partitioning key of a partitioned table.
Ação do sistema: The statement cannot be executed. No data was updated in
the object table or view.
Resposta ao Desenvolvedor: 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.
SQLSTATE: 42808
© Copyright IBM Corp.
|