SQL COMMAND to see table relation
AS/400 DB2, SQL
Which command I can use to get the relation between all tables in a system application? Question
AS/400 DB2, SQL
Which command I can use to get the relation between all tables in a system application? 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
Hi,
You can use DSPDBR to see the relationships for files/tables. If you want to see a graphical overview you can use I Series Navigator (Click on your machine, expand the tree for it, Goto Databases, then Database Navigator Maps, Right click and select New, then Map. Select the library/libraries you want the map for and let it build the map. This can be quite a complicated view).
Hope this helps.
Regards,
Martin Gilbert.
Browse more Questions and Answers on AS/400 and Development.
Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.
