SQL Codes › SQL Return Codes -1 through -999 › -17 - MODIFICATION OF COLUMN TO INCOMPATIBLE DATATYPE IS NOT ALLOWED

-17 - MODIFICATION OF COLUMN TO INCOMPATIBLE DATATYPE IS NOT ALLOWED

Reason:

You issued an ALTER TABLE attempting to modify the data type of an existing column. The data type requested is not compatible with the original, so the data values in the table cannot be converted.

The SQLSTATE that equates to this SQL return code is 53S01.

Action:

There are two options. Either change the ALTER TABLE to request a compatible data type, or follow these steps:

1. Add a new column to the table with the desired data type.
2. (Optional) Issue an UPDATE request to assign a value to the new column for each row of the table. These values may not be assigned directly from the column that has the incompatible data type.
3. Issue an ALTER TABLE to drop the original column. See rules for dropping columns in the ALTER TABLE chapter of the CA Datacom/DB SQL User Guide.
4. (Optional) Issue an ALTER TABLE to rename the new column to match the name of the dropped column.