Hi,

What is purpose of "ENFORCED" in ADD CONSTRAINT command? What is different if "ENFORCED" is not used?

Sample:
ALTER TABLE DB2ADMIN.TEST ADD CONSTRAINT CC1149671640818 CHECK (CO1 IN ('A','B','C')) ENFORCED ENABLE QUERY OPTIMIZATION ;

Thanks,
Grofaty

You can define a constraint without enforcing it ...
ie , in the above example if you have used 'NOT ENFORCED' instead of ENFORCED, then you will be able to insert a record with a value of D in COL1.
NOT ENFORCED is used when you are sure that the data is correct but want to let the optimizer know about the constraint ... As an example, in a star schema, you can define a refrential contraint between fact and dimension without enforcing it ... This way, the optimizer will know the relationship between the two tables, but the database engine will not enfore the referential constraint

HTH

Sathyaram

Sathyaram_s,

Thanks a lot. What is default value if I omit the enfore clause just like this:
ALTER TABLE DB2ADMIN.TEST ADD CONSTRAINT CC1149671640818 CHECK (CO1 IN ('A','B','C'))

The above command is working and it looks like "enforced" is used as default. Is this correct?

Thanks,
Grofaty

You are right

Sathyaram