User did a schema compare ALTSDDB and ALTSTDB, Toad found differences on constraint and generated DDL with mixed schema names.
For example:
ALTER TABLE "ALTStDB"."TCHEND"
ADD CONSTRAINT "CHIMPK2_FK" FOREIGN KEY
("CHARGE_NMBR", "DCMNT_DISTRICT_CD", "TITLE_NMBR", "LTB_DISTRICT_CD")
REFERENCES "ALTSdDB"."TCHIMP"
("CHARGE_NMBR", "DCMNT_DISTRICT_CD", "TITLE_NMBR", "LTB_DISTRICT_CD")
ON DELETE CASCADE
ON UPDATE NO ACTION
ENFORCED
ENABLE QUERY OPTIMIZATION;
STATUS
Waiting for a fix with ST 83569 on a future release of Toad for DB2.
WORKAROUND:
None
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center