Menu principal                 [Fechar]


SQL - SQLCODE's - Códigos negativos


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por Carlos Alberto Dornelles - Analista de Sistemas - Brasília DF.


SQLCode -151

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.