I am trying to expand a column from SMALLINT to BIGINT. I get the error: SQL0104N An unexpected token "BIGINT" was found following ""TYPE SET DATA TYPE". Expected tokens may include:"". SQLSTATE=42601
On the DB2 reference for Alter Table you can only alter string (VARCHAR) related data types.
The alternative is to add a new column