Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008
    Posts
    88

    Unanswered: delete from cursor

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    can you please provide more info. Post delete statement and also DB2 version/edition operating system name/version.
    Grofaty

  3. #3
    Join Date
    Jun 2004
    Posts
    3
    According to the number of lignes to be deleted, rather than deleting you can unload all that you want to keep then load replace...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •