Structure and data of copy table on DB2

Now there is a row of data, to be copied to multiple lines, each row only two field values are different, DB2 no SQL Server top keyword, the only want to copy a few times, and then update the data, found no.

Then think of a temporary create a table B, insert this row of data, and then constantly modify B and then insert a.

DB2 Copy Table structure:

CREATE TABLE Table_name_new as (SELECT * from table_name_old) definition only;

Inserting data

INSERT INTO Table_name_new (SELECT * from Table_name_old);

You can also use export, import to insert data

--duplicate table structure, but do not copy primary KEY, constraint, index ...

CREATE table table_name_new like Table_name_old;

Structure and data of copy table on DB2