Altering BYTE and TEXT Column data types

You can use the MODIFY clause to change a BYTE column to a TEXT column, and vice versa. You can also use the MODIFY clause to change a BYTE column to a BLOB column and a TEXT column to a CLOB column.

Except for these operations, however, you cannot use the MODIFY clause to change a BYTE or TEXT column to any other type of column, nor to change any other type of column to a BYTE or TEXT column.

When you use this clause to change a BYTE column to a BLOB column, or to change a TEXT column to a CLOB column, you can also use the PUT Clause of the ALTER TABLE statement to specify an sbspace and to define its characteristics for storing the BLOB or CLOB objects.