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


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 -503

   
 
  • Causa
    • A COLUMN CANNOT BE UPDATED BECAUSE IT IS NOT IDENTIFIED IN THE UPDATE CLAUSE OF THE SELECT STATEMENT OF THE CURSOR.

      The application program attempted to update (using a cursor) a value in a column of the object table that was not identified in the FOR UPDATE clause in the cursor declaration.

      Any column that is to be updated must be identified in the FOR UPDATE clause of the cursor declaration.
  • Ação do sistema
    • The statement cannot be executed.
      No data was updated in the object table.
  • Resposta ao Desenvolvedor
    • Correct the application program.
      If the column is to be updated, its name must be added to the FOR UPDATE clause of the cursor declaration.

      SQLSTATE: 42912

© Copyright IBM Corp.