-20177   SET DATA TYPE CLAUSE ON ALTER TABLE SPECIFIED FLOATING POINT, BUT THIS CHANGE IS DISALLOWED

Explanation

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 different compatible data type, and resubmit the statement.

SQLSTATE

530A1