zOs/TX/MFNVZDEI

declare global temporary table  session.keys as
  ( select MF150013, MF150067 from oa1a.tmf150a1 )
    with no data
    on commit delete rows
;
select MF150013, MF150067, count(*)
    from oa1a.tmf150a1
    group by MF150013, MF150067
    fetch first 10 rows only
;
insert into session.keys
    select MF150013, MF150067 from
      ( select MF150013, MF150067
              from oa1a.tmf150a1
              fetch first 10 rows only
      ) i
      group by MF150013, MF150067
;
select * from session.keys;
insert into oa1a.tmf150H1 (
      MF150001    ,
      MF150002    ,
      MF150003    ,
      MF150004    ,
      MF150005    ,
      MF150006    ,
      MF150007    ,
      MF150008    ,
      MF150009    ,
      MF150010    ,
      MF150011    ,
      MF150012    ,
      MF150013    ,
      MF150014    ,
      MF150015    ,
      MF150016    ,
      MF150017    ,
      MF150018    ,
      MF150019    ,
      MF150020    ,
      MF150021    ,
      MF150022    ,
      MF150023    ,
      MF150024    ,
      MF150025    ,
      MF150026    ,
      MF150027    ,
      MF150028    ,
      MF150029    ,
      MF150030    ,
      MF150031    ,
      MF150032    ,
      MF150033    ,
      MF150034    ,
      MF150035    ,
      MF150036    ,
      MF150037    ,
      MF150038    ,
      MF150039    ,
      MF150040    ,
      MF150041    ,
      MF150042    ,
      MF150043    ,
      MF150044    ,
      MF150045    ,
      MF150046    ,
      MF150047    ,
      MF150051    ,
      MF150052    ,
      MF150053    ,
      MF150054    ,
      MF150055    ,
      MF150056    ,
      MF150059    ,
      MF150060    ,
      MF150062    ,
      MF150063    ,
      MF150064    ,
      MF150065    ,
      MF150066    ,
      MF150067    ,
      MF150068    ,
      MF150069    ,
      MF150070    ,
      MF150071    ,
      MF150072    ,
      MF150073    ,
      MF150074    ,
      MF150075    ,
      MF150076    ,
      MF150077    ,
      MF150078    ,
      MF150079    ,
      MF150080    ,
      MF150081    ,
      MF150082    ,
      MF150083    ,
      MF150084    ,
      MF150085    ,
      MF150086    ,
      MF150087    ,
      MF150088    ,
      MF150089    ,
      MF150090    ,
      MF150091    ,
      MF150092    ,
      MF150019A   )
    select
      MF150001    ,
      MF150002    ,
      MF150003    ,
      MF150004    ,
      MF150005    ,
      MF150006    ,
      MF150007    ,
      MF150008    ,
      MF150009    ,
      MF150010    ,
      MF150011    ,
      MF150012    ,
      MF150013    ,
      MF150014    ,
      MF150015    ,
      MF150016    ,
      MF150017    ,
      MF150018    ,
      MF150019    ,
      MF150020    ,
      MF150021    ,
      MF150022    ,
      MF150023    ,
      MF150024    ,
      MF150025    ,
      MF150026    ,
      MF150027    ,
      MF150028    ,
      MF150029    ,
      MF150030    ,
      MF150031    ,
      MF150032    ,
      MF150033    ,
      MF150034    ,
      MF150035    ,
      MF150036    ,
      MF150037    ,
      MF150038    ,
      MF150039    ,
      MF150040    ,
      MF150041    ,
      MF150042    ,
      MF150043    ,
      MF150044    ,
      MF150045    ,
      MF150046    ,
      MF150047    ,
      MF150051    ,
      MF150052    ,
      MF150053    ,
      MF150054    ,
      MF150055    ,
      MF150056    ,
      MF150059    ,
      MF150060    ,
      MF150062    ,
      MF150063    ,
      MF150064    ,
      MF150065    ,
      MF150066    ,
      MF150067    ,
      MF150068    ,
      MF150069    ,
      MF150070    ,
      MF150071    ,
      MF150072    ,
      MF150073    ,
      MF150074    ,
      MF150075    ,
      MF150076    ,
      MF150077    ,
      MF150078    ,
      MF150079    ,
      MF150080    ,
      MF150081    ,
      MF150082    ,
      MF150083    ,
      MF150084    ,
      MF150085    ,
      MF150086    ,
      MF150087    ,
      MF150088    ,
      MF150089    ,
      MF150090    ,
      MF150091    ,
      MF150092    ,
      MF150019A
   from oa1a.tmf150a1
   where (MF150013, MF150067) in
     ( select MF150013, MF150067
           from session.keys)
;
delete from oa1a.tmf150a1
   where (MF150013, MF150067) in
     ( select MF150013, MF150067
           from session.keys)
;
rollback
;