zOs/SQL/TWK09CO

select * from A540769.TWK009A ;
update A540769.TWK009A set wk009for = '01';    ;
update A540769.TWK009A set wk009for = '02';    ;
update A540769.TWK009A set wk009for = '7';    ;
update A540769.TWK009A set wk009for = null;    ;
delete from A540769.TWK009A where wk009id not like '7%';
select * from A540769.TWK009A ;
commit;
delete from A540769.TWK009A;
insert into A540769.TWK009A (wk009id, wk009Txt)
    values('01'      , 'eins'              );
insert into A540769.TWK009A (wk009id, wk009Txt, wk009FOR)
    values('02'      , 'zwei'              , '02'  ) ;
insert into A540769.TWK009A (wk009id, wk009Txt)
    values('7'       , '7'                 );
insert into A540769.TWK009A (wk009id, wk009Txt, wk009FOR)
    values('71'      , '71'                , '7'   ) ;
insert into A540769.TWK009A (wk009id, wk009Txt, wk009FOR)
    values('72'      , '72'                , '7'   ) ;
insert into A540769.TWK009A (wk009id, wk009Txt, wk009FOR)
    values('73'      , '73'                , '7'   ) ;
insert into A540769.TWK009A (wk009id, wk009Txt, wk009FOR)
    values('711'     , '711'               , '71'  ) ;
insert into A540769.TWK009A (wk009id, wk009Txt, wk009FOR)
    values('712'     , '712'               , '71'  ) ;
insert into A540769.TWK009A (wk009id, wk009Txt, wk009FOR)
    values('721'     , '721'               , '72'  ) ;
insert into A540769.TWK009A (wk009id, wk009Txt, wk009FOR)
    values('732'     , '732'               , '73'  ) ;
insert into A540769.TWK009A (wk009id, wk009Txt, wk009FOR)
    values('7211'    , '7211'              , '721' ) ;
insert into A540769.TWK009A (wk009id, wk009Txt, wk009FOR)
    values('72111'   , '72111'             , '7211') ;
select * from A540769.TWK009A
;
-- rollback;