How to delete rows in block on DB2
use the option fetch first <number_of_rows> rows only to delete in block
Table: employee
Size of Block: 1000
db2 delete from employee where col1 in (select col1 from employee fetch first 1000 rows only )with the statement above you can apply in loop to insert in many blocks
No comments:
Post a Comment