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


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

   
 
  • Causa
    • THE INDEX CANNOT BE CREATED OR THE LENGTH OF A COLUMN CANNOT BE CHANGED BECAUSE THE SUM OF THE INTERNAL LENGTHS OF THE IDENTIFIED COLUMNS IS GREATER THAN THE ALLOWABLE MAXIMUM.

      The index could not be created or the length of a column cannot be changed because the sum of the internal lengths of the key columns would exceed the allowable maximum.
      The maximum permitted key length is 255.
  • Ação do sistema
    • The statement cannot be executed.
      The specified index was not created or the length of the column was not changed.
  • Resposta ao Desenvolvedor
    • The definition for the index must be modified (possibly by eliminating one or more key columns) to reduce the length of the key to the permitted maximum.
      Refer to Chapter 5 of DB2 SQL Reference if you require a complete explanation of other possible maximum key lengths and how they are computed.

      SQLSTATE: 54008

© Copyright IBM Corp.