Getting started with db2 Combine multiple rows into a single comma separated value Hello World;Insert into one table by selecting from another table Where not in multiple columns Parse comma-separated values in a column into multiple rows dashDB Copy table with or without data DB2 Constraint Information Drop table

Insert into one table by selecting from another table

Insert into one table by selecting from another table

insert into schema.table (field1, field2)
  select 'Static Value', foreignField from schema.otherTable;

Contributors

Topic Id: 6306

Example Ids: 21788

This site is not affiliated with any of the contributors.