zOs/SQL/CRETRIPI

select * from gdb9998.twk077a;
x
update gdb9998.twk077a set wk077key  = wk077key  + 1;
select * from gdb9998.twk077a;
commit;
   x
delete   from gdb9998.twk077a;
insert into gdb9998.twk077a values (77, 30, 'dreissig');
insert into gdb9998.twk077a (wk077key, wk077txt)
                            values(31, 'einUndDreissig');
insert into gdb9998.twk077a values (77, 32, 'zweiUndDreissig');
select * from gdb9998.twk077a;
update gdb9998.twk077a set wk077Part = 99;
select * from gdb9998.twk077a;
insert into gdb9998.twk077a
      select wk077Key + 55, wk077Key + 10, '+zenh'
          from gdb9998.twk077a;
insert into gdb9998.twk077a
      select wk077Key + 55, wk077Key + 20, '+zwan'
          from gdb9998.twk077a;
insert into gdb9998.twk077a
      select wk077Key + 55, wk077Key + 55, '+ff'
          from gdb9998.twk077a;
select * from gdb9998.twk077a;
commit;