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


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 -541
   
 
  • Causa
    • DUPLICATE TEMPORAL FOREIGN KEY CONSTRAINT EXISTS FOR TABLE table-name (constraint name).

      An attempt was made to add a FOREIGN KEY constraint.
      The table already has a constraint that is a duplicate of the constraint being added.
      A temporal FOREIGN KEY constraint is a duplicate if the columns in the constraint are the same as in another temporal foreign key constraint.
      An attempt was made to use the table in a FOREIGN KEY clause or in an SQL manipulative statement.
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • The constraint is already in effect.

      SQLSTATE: 42891
© Copyright IBM Corp.