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