Every DB2 admin discovers sooner or later that DB2 can not add identity column to existing table easily. Following statements fails due to syntax error: alter table public.clicks add column id integer generated always as identity
But i have good news for everyone. It can be still done, but it requires more steps.
1. Add not null integer column
You need to provide default value for it otherwise db2 will refuse it to make not…Continue