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


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

   
 
  • Causa
    • THE PRIMARY KEY CANNOT BE UPDATED BECAUSE OF MULTIPLE-ROW UPDATE.

      An UPDATE operation attempted to update a primary key on multiple rows of the object table.

      Nota: This SQLCODE will only be issued for plans and packages bound prior to Version 5.
      SQLCODE -534 will not be issued for dynamic SQL or plans and packages bound with Version 5 or later releases.
  • Ação do sistema
    • The UPDATE statement cannot be executed.
      The contents of the object table are unchanged.
  • Resposta ao Desenvolvedor
    • Examine the search condition of the UPDATE statement to make sure that no more than one row of the object table is selected to be updated.

      SQLSTATE: 21502

© Copyright IBM Corp.