logo  
Google
 

DB2 SQL-Error: -767

SQLState: 42626

Short Description: MISSING OR INVALID COLUMN SPECIFICATION FOR INDEX

The CREATE INDEX statement failed for one of the following reasons: v An index on a non-auxiliary table must specify the columns on which the index is defined. v An index on an auxiliary table must not have a column specification.System action: The statement cannot be executed. Programmer response: Correct the syntax of the CREATE INDEX statement. v To create an index on a non-auxiliary table, specify the columns on which the index is defined. v To create an index on an auxiliary table, do not specify the name of any column.

 <-  BACK TO INDEX