DB2 : Alter Column Datatype Resize

Syntax:

Alter table tablename Alter column columnname set DATA TYPE VARCHAR(10)

Example:

ALTER TABLE TBL_EMPLOYEE ALTER COLUMN EMP_NAME SET DATA TYPE VARCHAR(300)