I have tried to ways you are sending

> set integrity A off
> set integrity A all immediate unchecked
> trying to delete from A again

I still could not run the delete

> My purpose is to go straight to delete from A then I will do check all? how could I defer the RI check to the last
minutes?

my reading about CASCADE DEFFERED but I don't think it is the one I need...

have you done this before?

Thanks all for your reply,
A.p


-----Original Message-----
From: Pham Anh
[mailto:db2udbdba-ezmlmshield-x29133085.[Email address protected]
Sent: July 31, 2006 3:14 PM
To: LazyDBA Discussion
Subject: Could not delete > urgent



Hi all,

would you help me a way out

Parent table is A
Child table is B

A-B both now is in normal access

What SET integrity order I have to set to be able:

+ to DELETE from A where A.xxxx =...
+ then I will be able check all after that

Thanks so much


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page