drop   table orig0_table;
create table orig0_table
  (
      attrib#1 int  not null generated always as identity primary key
    , attrib#2 date not null default current_date
    , attrib#3 date not null 
    , attrib#4 date generated always as (case when year(attrib#2) < 1980
                                             then attrib#2 + 1 year
                                             else attrib#3 - 3 months
                                         end)  
  );
 
insert   into orig0_table (attrib#2 , attrib#3) values ('1959-04-26' , '1985-09-22'  );
insert   into orig0_table (attrib#2 , attrib#3) values ('1985-09-22' , current_date  );
insert   into orig0_table (attrib#2 , attrib#3) values ('2000-01-01' , '2112-12-21'  );
insert   into orig0_table (attrib#3) values ( '1111-11-11');
insert   into orig0_table (attrib#3) values ( '1212-12-12');
select * from orig0_table;
------
drop   table copy1_table;
create table copy1_table
       like  orig0_table;
------
declare   x1    cursor for select *  from orig0_table                ; 
load from x1 of cursor     insert    into copy1_table nonrecoverable ;
------
insert   into copy1_table (attrib#3) values ( '111-11-11');
insert   into copy1_table (attrib#3) values ( current_date);
select * from copy1_table;
------