SQL - SQLCODE's - Códigos positivos - +664


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 +664
   
 
  • Causa
    • THE INTERNAL LENGTH OF THE LIMIT-KEY FIELDS FOR THE PARTITIONED INDEX index-name EXCEEDS THE LENGTH IMPOSED BY DB2

      The ALTER INDEX statement can change a limit key for the partitioned index (that is, the cluster index for a table residing in a partitioned table space), and the length of the limit key exceeds the permitted maximum.

      DB2 restricts the internal length of the limit keys for a partitioned index to a maximum of 40 bytes.
      The sum of the internal lengths of the limit keys specified in the PART clause of the ALTER INDEX statement exceeds that 40-byte maximum.
      The limit key was truncated to 40 bytes.
  • Ação do sistema
    • The specified index was altered but the limit key was truncated to 40 bytes.

      SQLSTATE: 01540