select count(*) from A540769.TWK600A021
; -- beschränktes delete 1
delete from A540769.TWK600A021
where (i1, v2) in
(select r.i1, r.v2
from A540769.TWK600A021 r
order by r.i1, r.v2
fetch first 100 rows only
)
;
select count(*) from A540769.TWK600A021
;
delete from A540769.TWK600A021
where (i1, v2) in
(select r.i1, r.v2
from A540769.TWK600A021 r
order by r.i1, r.v2
fetch first 100 rows only
)
;
select count(*) from A540769.TWK600A021
;
rollback;