Hi all,

I have a delete query which takes too long to delete the data. I wanted to try to delete from cursor but not tooo sure whether it will make my deletes any faster. Does anyone has used delete from cursor. Does it has made any difference..Just wanted to take some guidance before implementing

Hi,
can you please provide more info. Post delete statement and also DB2 version/edition operating system name/version.
Grofaty

According to the number of lignes to be deleted, rather than deleting you can unload all that you want to keep then load replace...