db2 Insert into one table by selecting from another table Insert into one table by selecting from another table
Example
insert into schema.table (field1, field2)
select 'Static Value', foreignField from schema.otherTable;
insert into schema.table (field1, field2)
select 'Static Value', foreignField from schema.otherTable;
