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


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 -544
   
 
  • Causa
    • THE CHECK CONSTRAINT SPECIFIED IN THE ALTER TABLE STATEMENT CANNOT BE ADDED BECAUSE AN EXISTING ROW VIOLATES THE CHECK CONSTRAINT.

      An existing row violates the check constraint specified in the ALTER TABLE statement.
  • Ação do sistema
    • The statement cannot be executed.
      The check constraint definition is not added to the table.
      The table definition is unchanged.
  • Resposta ao Desenvolvedor
    • Examine the check constraint definition that was specified in the ALTER TABLE statement and the data in the table to determine why the ALTER TABLE statement was rejected.

      You can determine which rows violated the check constraint by using the SELECT statement, negating the check constraint in the WHERE clause.
      For example: 
      SELECT * FROM table WHERE (NOT (check-condition));
      SQLSTATE: 23512

© Copyright IBM Corp.