If you are trying to switch all the constraints on or off in one go then SET INTEGRITY is fine else ALTER TABLE as suggested by Rao should be fine as it gives more granular control.
-----Original Message-----
From: Lekharaju Ennam
[mailto:db2udbdba-ezmlmshield-x66886933.[Email address protected]
Sent: 26 May 2005 13:38
To: LazyDBA Discussion
Subject: RE: Constraints
that is oracle not DB2
Lekharaju Ennam
-----Original Message-----
From: Rao V Chinnam
[mailto:db2udbdba-ezmlmshield-x55250172.[Email address protected]
Sent: Thursday, May 26, 2005 7:47 AM
To: LazyDBA Discussion
Subject: Re: Constraints
Use ALTER TABLE ADD CONSTRAINT ....
and ALTER TABLE DROP CONSTRAINT ...
"Premnath "
<db2udbdba-ezmlms
hield-x35471969.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
05/26/2003 01:11
AM Subject
Constraints
hi DBA's
How do we enable and disable the constraints of a table in DB2 8.2 ?
Regards
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
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