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


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

   
 
  • Causa
    • A cláusula PART de um comando ALTER está omitida ou inválida.

      A declaração ALTER é inválida para uma das seguintes razões:
      • The table space or index is not partitioned and the PART clause is specified.
      • The table space or index is partitioned, a partition attribute (FREEPAGE or PCTFREE) is specified, and the PART clause is not specified.
      • The integer specified in the PART clause does not identify a partition of the table space or index.
      • A USING, PRIQTY, SECQTY, or ERASE clause is used to alter storage attributes, but the partition is not specified.
      • A GBPCACHE clause is used to alter the group buffer pool caching attributes, but the partition is not specified.
      • The VALUES clause is specified without the PART clause.
        You must specify PART to change VALUES.
  • Ação do sistema
    • The SQL statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Determine whether the table space or index you want to alter is partitioned.
      If it is partitioned, specify a PART clause that identifies the partition you want to alter. If it is not partitioned, do not specify the PART clause.

      SQLSTATE: 53039

© Copyright IBM Corp.