Personal tools
You are here: Home → DB2 → How To's → How to delete rows in block on DB2
Navigation
Log in


Forgot your password?
 
Document Actions

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

 

Related content
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls