Wednesday, 4 June 2014

How to delete rows in block on DB2

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