var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Insert into a table with identity col
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...
I think you should get used to specifying columns that you want to insert into. Correct syntax can be found in the manual.