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


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

   
 
  • Causa
    • THE DELETE RULE MUST BE delete-rule.

      The code is used to report that the 'delete-rule' specified in a FOREIGN KEY clause of the ALTER TABLE statement is invalid.
      The indicated 'delete-rule' is required because:
      • A self-referencing constraint must have a 'delete-rule' of CASCADE or NO ACTION.
      • The relationship would cause the table to be delete-connected to the same table through multiple paths and such relationships must have the same 'delete-rule'.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Change the 'delete rule' in the FOREIGN KEY clause.

      SQLSTATE: 42915

© Copyright IBM Corp.