Aviso importante
Caso tenhas alguma
dúvida a respeito
da linguagem mande
um e-mail que terás
a resposta.
  C. A. Dornelles

SQL - SQLCODE's - Códigos positivos


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF.

SQLCode +664
THE INTERNAL LENGTH OF THE LIMIT-KEY FIELDS FOR THE PARTITIONED INDEX index-name EXCEEDS THE LENGTH IMPOSED BY DB2

Causa
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