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


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 -538
   
 
  • Causa
    • FOREIGN KEY name DOES NOT CONFORM TO THE DESCRIPTION OF A PARENT KEY OF TABLE table-name. The definition of the indicated foreign key does not conform to the description of parent key of the indicated table due to one of the following reasons:
      • The referenced parent kkey has not been defined as a primary key or a unique key.
      • The keys do not have the same number of columns.
      • The decription of the keys are not identical.

      name is the constraint-name specified in the foreign key clause or, if a constraint-name was not specified, the first column-name specified in the clause.
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Correct the statement so that the description of the foreign key references a primary key or unique key, or so that the description of the foreign key conforms to that of a parent key of the indicated table.

      SQLSTATE: 42830

© Copyright IBM Corp.