it is not possible to do it with ALTER TABLE foo ALTER COLUMN but you could rename table, create new one (just like you want to) (using DDL) and then copy data back using:
"INSERT INTO tablename (colnames,...) SELECT colnames, ... FROM tablename_copy"
Originally posted by huangs773
DB2 7.1 OS/390
Is is possible to make a
SMALLINT NOT NULL
SMALLINT NOT NULL generated always as identity
with ALTER TABLE foo ALTER COLUMN?