Alter DB2 Column: Change Type & Length

To change the data type and length of a DB2 table column, you can use the ALTER TABLE statement.

For example, to change the field type from VARCHAR(50) to VARCHAR(100) in the table, you can use the following statement:

ALTER TABLE table_name
MODIFY COLUMN column_name VARCHAR(100);

This will alter the data type of the column_name field in the table table_name to VARCHAR(100).