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


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

   
 
  • Causa
    • FOREIGN KEY name IS TOO LONG OR HAS TOO MANY COLUMNS.

      This code is used to report that the sum of the length attributes of the columns identified in the indicated FOREIGN KEY clause is greater than 255 bytes or the number of columns identified is greater than 64.
      The '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 executed.
  • Resposta ao Desenvolvedor
    • The table definition must be modified to conform to the system-imposed limit of the sum of the length attributes of the columns identified in the PRIMARY KEY clause.

      SQLSTATE: 54008

© Copyright IBM Corp.