Topic
IC4NOTICE: 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.
No replies
SystemAdmin
SystemAdmin
2826 Posts
ACCEPTED ANSWER

Pinned topic How to Enable Enforce on a table in DB2

‏2012-11-26T11:07:05Z |
Hi,
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