-767   MISSING OR INVALID COLUMN SPECIFICATION FOR INDEX index-name

Explanation

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.

System action

The statement cannot be processed.

Programmer response

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