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


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

   
 
  • Causa
    • THE INSERT OR UPDATE VALUE OF FOREIGN KEY constraint-name IS INVALID.

      An UPDATE or INSERT operation attempted to place a value in a foreign key of the object table;

      however, this value was not equal to some value of the parent key of the parent table.

      When the value of the foreign key is updated, the update value of a foreign key must be equal to the value of the parent keyof some row of the parent table of the associated relationship.
  • Ação do sistema
    • The UPDATE or INSERT statement cannot be executed.
      The object table is unchanged.
  • Resposta ao Desenvolvedor
    • Examine the insert or update value of the foreign key first, and then compare it with each of the parent keyvalues of the parent table to determine the cause of the problem.

      SQLSTATE: 23503

© Copyright IBM Corp.