Delete All Data

ratheeshknair · #1 (**permalink**) 08-12-09, 01:31

Hi Experts,

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

TIA

umayer · #2 (**permalink**) 08-12-09, 03:03

LOAD REPLACE ENFORCE NO with an empty load-dataset, and CHECK DATA afterwards

ibm_db2_rocks · #3 (**permalink**) 08-12-09, 04:06

LOAD from /dev/null

ratheeshknair · #4 (**permalink**) 08-12-09, 08:55

I am using windows XP and what exactly i need to give? Wher i have to specify the table name?

TIA

rahul_s80 · #5 (**permalink**) 08-12-09, 09:56

First... Have you checked the load command syntax ?
you need to work on Hints provided here...

ratheeshknair · #6 (**permalink**) 08-13-09, 02:46

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

Internet Services

Web Development

Digital Marketing

Consumer Tech