SQL COMMAND to see table relation

5 pts.
Tags:
AS/400 DB2
SQL
Which command I can use to get the relation between all tables in a system application?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following