Hello,

I have to select cols from a table and insert into another table which is having col integer generated always as identity.

for example T1 has 5 cols.T2 has same 5 cols + identity col.

What would be the syntax.

I am trying the following but not working

db2 "insert into dev04.identity2 (Select HSN,C3,C4 from dev04.identity1)"

Can anyone give me the right syntax...

Thanks

I think you should get used to specifying columns that you want to insert into. Correct syntax can be found in the manual.