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


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

   
 
  • Causa
    • MISSING OR INVALID COLUMN SPECIFICATION FOR INDEX index-name

      The CREATE INDEX statement failed for one of the following reasons:
      • An index on a non-auxiliary table must specify the columns on which the index is defined.
      • An index on an auxiliary table must not have a column specification.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Correct the syntax of the CREATE INDEX statement.

      • To create an index on a non-auxiliary table, specify the columns on which the index is defined.
      • To create an index on an auxiliary table, do not specify the name of any column.

      SQLSTATE: 42626
© Copyright IBM Corp.