Is there a 'non-mandatory' relationship in DB2 8 for Z/OS?

Question posted by: BD (Guest) on July 25th, 2008 04:35 PM

I'm working with a data model which is managed in the AllFusion ERwin
tool.

Within the modeler, some of the FK relationships are 'non-mandatory' -
which is to say that for a given child value, a parent value is
optional. This is different from an optional child key, where the
child table allows null values - in this case it's the relation itself
that is optional. Strikes me as rather contrary to the principles of
RI...

From what I can find, there is no such provision in DB2. I generated
DDL from within the tool with a specific relation set as Mandatory,
and then as Optional - there was no difference in the generated RI
DDL, suggesting that this provision within the ERwin tool is
effectively ignored.

I did scour the online db2 documentation, checking as many different
books as I could find relevant references in the Master Index - and
found no reference to any provision like this.

Can anyone confirm whether such 'non-mandatory' RI exists within DB2?

Thanks,

BD

Not the answer you were looking for? Post your question . . .
190,182 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).