DSXchange

Is there any way to resolve a database foreign key relationship automatically in DataStage. My input is e.g. a partner id and then I want to extract all data from tables which are related to this specific partner (there are existing multilevel dependencies).

Not really.

If you import from a DCLGen and the foreign key relationships are stated in that, then DataStage will detect them.

You can manually edit DataStage's "table definitions" that result from the import, and thus identify foreign key relationships, but I don't believe there is any way for DataStage actually to detect these relationships.

Of course, if you are aware that the relationship exists you can design accordingly. But that's not quite the same thing.