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


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

   
 
  • Causa
    • Índice index-name não pode ser criado ou partilhado porque chaves limites não foram especificadas.

      The CREATE INDEX or ALTER INDEX statement did not specify limit key values for the partitions of the table space.
      To create a clustering index for a table in a partitioned table space, or to modify those values using ALTER INDEX, you must include those values.
  • Ação do sistema
    • The statement cannot be executed.
      The specified cluster index was not created or altered.
  • Resposta ao Desenvolvedor
    • Verify that the correct table was specified in the CREATE INDEX or ALTER INDEX statement.
      If so, the definition for the partitioned table space must be examined so that a proper definition for the cluster index for the table may be constructed.
      Refer to Chapter 5 of DB2 SQL Reference for information about the requirements that must be satisfied by the definitions for the cluster indexes for partitioned tables.

      SQLSTATE: 53035

© Copyright IBM Corp.