zOs/SQL/EXFINAL
select * -- final table
from final table
(
insert into A540769.twk600a011 (PART, i1, i2, v2, v3)
select PART, i1, i2, v2, v3
from A540769.twk600a011
where part = 7
fetch first 5 rows only
)
;
select * -- final table with include
from final table
(
insert into A540769.twk600a011 (PART, i1, i2, v2, v3)
include(frueher date, v1Old varchar(1000))
select PART, i1, i2, v2, v3
, current date - row_number() over () days, v1
from A540769.twk600a011
where part = 7
fetch first 5 rows only
)
;
select * -- old table
from old table
(
delete from A540769.twk600a011
where part = 7 and v1 is null
)