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


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

   
 
  • Causa
    • THE ALTER INDEX CANNOT BE EXECUTED, REASON reason. The ALTER INDEX statement cannot be executed for one of the following reasons:
      1   Alter to type 1 index is not allowed for the index whose associated table space has a LOCKSIZE specification of ROW.
      2   Alter to type 1 index is not allowed for the index defined with UNIQUE WHERE NOT NULL.
      3   Alter to type 1 index is not allowed for the index whose associated table space has been defined as a LARGE table space.
      4   Alter to type 1 index is not allowed for an index on an ASCII table.
      5   Alter PIECESIZE is not allowed for a partitioning index.
      6   Alter PIECESIZE 4G is not allowed for non-partitioned indexes on a non-LARGE table.
      11   Alter VALUES is not allowed for an index on a partitioned base table with LOB columns.
  • Ação do sistema
    • The ALTER INDEX statement is not executed.
  • Resposta ao Desenvolvedor
    • Correct the error according to the given reason and execute the statement again.

      SQLSTATE: 56090

© Copyright IBM Corp.