sql - db2 set incrementing values using insert statement -

sql - db2 set incrementing values using insert statement -

i have 2 tables:

mytable1 id |col1|col2 | --------------------- .... 64 | 50 | 7000 | mytable2 my_id | ------- 64 | 87 |

and need insert 10,000 rows mytable1 id=my_id col1=50 ant col2 increments each time row inserted mytable1 that:

id |col1|col2 | --------------------- .... 64 | 50 | 7000 | 87 | 50 | 7001 |

i have found similar solution here: insert thousands of rows in db2

but still cant figure out how load ids mytable2

please help, give thanks answers.

insert mytable1 (id, col1, col2) select my_id, 50 col1, col2 + row_number() over(order my_id) ( select my_id, m.col2 mytable2 t2, (select max(col2) col2 mytable1) m ) t2 -- if don't want insert ids exist in mytable1 not exists (select 1 mytable1 t1 t1.id = t2.my_id);

sql database insert db2 increment