Multiple parents..?

[sKrEwBaLL]

Hi

This is probably a silly question, maybe I am clutching at straws here, but it is possible to have multiple parents in a relationship. For example, is it possible to set up a foreign key which looks at table_x OR table_y for the same column.

We have DB2 7.1.1 for Z/OS.

Cheers

Neil

 

[gregsimpson]

Neil,

not tried it but is it possible to set the relationship using a view, which would contain both table_x or table_y.

Cheers
Greg

 

[sKrEwBaLL]

Hi Greg,

Just tried that, but I get sqlcode -157, "Only a table name can be specified in a foreign key clause".

Thanks for trying!

Neil

 

[gregsimpson]

Neil,

In which case maybe you need to consider denormalising your database to achieve this?

Cheers
Greg

 

[sKrEwBaLL]

Managed to find a workaround which involves adding a column to the parent table and adding a predicate to the existing views.

Cheers