logo  
Google
 

DB2 SQL-Error: -678

SQLState: 53045

Short Description: THE LITERAL SPECIFIED FOR THE INDEX LIMIT KEY MUST CONFORM TO THE DATA TYPE OF THE CORRESPONDING COLUMN

The index limit key value literal has been specified incorrectly in the CREATE INDEX or ALTER INDEX statement. Limit key value specifications must conform to the data type of the corresponding index key column. In this case, literal must be of data type data-type to conform to the data type of column column-name. System action: The statement cannot be executed. The index was not created. Programmer response: Correct the statement so that each limit key value literal is of precisely the same data type as that of the corresponding index key column.

 <-  BACK TO INDEX