By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,627 Members | 1,188 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,627 IT Pros & Developers. It's quick & easy.

DB2v8.2 LUW. Unable to drop Foreign Key constraints...

P: 25
DB2v8.2 LUW. Unable to drop Foreign Key constraints...although DROP constraints returns undefined name. Am I missing somrthing here?

Hi all,
I have a perplexing DB2 Drop command situation. Environment I have tried severally to drop Foreign Key constraints on a set of tables and each time I get a SQL0204N "SQL071030104307060" is an undefined name. ".
However, when I go back to look at the table or load data, I get a constraint error telling me that the same constraint that is a undefined name still exist. I run a generate ddl command for the table, indeed the constraint still do exist!

Be assured that I am logged in to the right instance, database, etc.
What can possibly be the problem here? How can I make sure these constraints are dropped?

Here's an example of one that I have tried to drop but no avail:
ALTER TABLE "REPSP "."F_94_RPT_ADDR_T"
ADD CONSTRAINT "SQL071030104309760" FOREIGN KEY
("FAHIS_NBR_R")
REFERENCES "REPSP "."F_191_ABUSE_RPT_T"
("FAHIS_NBR_R")
ON DELETE RESTRICT
ON UPDATE NO ACTION


Thanks
Oct 31 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.