logo  
Google
 

DB2 SQL-Error: -740

SQLState: 54042

Short Description: C AN INDEX ALREADY EXISTS ON AUXILIARY TABLE

The CREATE INDEX statement would create a second index on the specified auxiliary table. An auxiliary table can have only one index. System action: The statement cannot be executed. Programmer response: An index already exists. Another index cannot be created.

 <-  BACK TO INDEX