DB2 SQL-Error: -190
SQLState: 42809
Short Description: THE ATTRIBUTES SPECIFIED FOR THE COLUMN ARE NOT COMPATIBLE WITH THE EXISTING COLUMN DEFINITION
The attributes that were specified in the ALTER COLUMN clause for the column column-name of the table table-name in an ALTER TABLE statement are not compatible with the attributes of the existing column. The error was returned for one of the follwing reasons: v If a SET DATA TYPE clause is specified, the existing column is not compatible with the new data type that was specified, or is of a data type that cannot be changed. The ALTER TABLE ALTER COLUMN SET DATA TYPE statement only allows changing columns of data type character or numeric. v If a RESTART, SET GENERATED, SET INCREMENT BY, SET MINVALUE, SET NO MINVALUE, SET MAXVALUE, SET NO MAXVALUE, SET CYCLE, SET NO CYCLE, SET CACHE, SET NO CACHE, SET ORDER, or SET NO ORDER clause is specified, the existing column is not defined as an identity column. These clauses can only be specified for a column that is defined as an identity column.System action: The statement cannot be executed. Programmer response: Make the attributes that are specified in the statement compatible with the existing column definition, remove the attribute specification, or specify a different column name.