Results 1 to 6 of 6

Thread: Delete All Data

  1. #1
    Join Date
    Jan 2009
    Posts
    153

    Unanswered: Delete All Data

    Hi Experts,

    How can i delete data from more than 150 tables having foreign relationships?

    TIA

  2. #2
    Join Date
    Dec 2005
    Posts
    273
    LOAD REPLACE ENFORCE NO with an empty load-dataset, and CHECK DATA afterwards

  3. #3
    Join Date
    Aug 2009
    Posts
    8
    LOAD from /dev/null

  4. #4
    Join Date
    Jan 2009
    Posts
    153
    I am using windows XP and what exactly i need to give? Wher i have to specify the table name?

    TIA

  5. #5
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    First... Have you checked the load command syntax ?
    you need to work on Hints provided here...
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  6. #6
    Join Date
    Jan 2009
    Posts
    153
    Yes Rahul,

    It caused the table to be load pending issued the set integrity command and the table is OK but caused my other table in no accessible state. One table having foreign key is causing the issue i think

Posting Permissions

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