Creating a table with an identity column works fine
create table test(a integer, id integer generated always as identity )
When I attempt to add an identity column it fails.
create table test2(a integer)
alter table test2 add column id integer generated always as identity
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0104N An unexpected token "IDENTITY" was found following "AS".
Expected
tokens may include: "<left_paren>". SQLSTATE=42601