Db2 Developer-C 11.1

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table one (id int generated always as identity, val varchar(10))
create table two (id int, ts timestamp)
select id, current_timestamp from final table (
insert into one (val) values ('foo'), ('bar'))


ID
2


1
2023-01-24 19:27:53.945262

2
2023-01-24 19:27:53.945262


with a (id) as (
select id from final table (
insert into one (val) values ('foo'), ('bar'))
)
select id from final table (
insert into two (id, ts) 
select id, current timestamp from a)


ID


3

4