Topic
  • No replies
SystemAdmin
SystemAdmin
2826 Posts

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