I have a table parent and child in DB2. i have populated values for child table alone.
I have now created relationship using the following query.
ALTER TABLE child ADD CONSTRAINT CC4563 FOREIGN KEY(COL1) REFERENCES parent (COL1) NOT ENFORCED ENABLE QUERY OPTIMIZATION
Then i ll populate the parent table. Now, How to I Enable ENFORCE again on child ?? what is the query/syntax to do the same.
Thanks in Advance
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.