Foreign Key Relationship
Moderators: chulett, rschirm, roy
Foreign Key Relationship
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).
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.