SQL - SQLCODE's - Códigos negativos -151


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode -151
   
 
  • Causa
    • 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.

      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.