logo  
Google
 

DB2 SQL-Error: -20177

SQLState: 530A1

Short Description: SET DATA TYPE CLAUSE ON ALTER TABLE SPECIFIED FLOATING POINT BUT THIS CHANGE IS DISALLOWED

The SET DATA TYPE clause of an ALTER TABLE statement specified floating point as the new data type. However, there is an existing unique index or constraint that is defined on the column. This type of change is not allowed when unique indexes or constraints are defined on the column to be changed. Programmer response: Change the statement to specify a diferent compatible data type, and resubmit the statement.

 <-  BACK TO INDEX