Q
Get started Bring yourself up to speed with our introductory content.

Determining relationships between tables and files in DB2 UDB

There is no SQL command that can simply determine relationships between tables and files on your iSeries. If you have referential integrity constraints in place, you can write queries against the system catalog objects such as QSYS2/SYSREFCST to determine related objects

Kent Milligan
IBM
Is there a command in sql that I can execute in order to show me the relation between all the tables/files used in my system application?
There's no SQL statement designed for that purpose. If you have referential integrity constraints in place, you can write queries against the system catalog objects such as QSYS2/SYSREFCST to determine related objects.

The System i Navigator (formerly iSeries Navigator) has a Database Navigator Map tool that is designed to perform this function graphically.

This was last published in May 2008

Dig Deeper on iSeries SQL commands and statements

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Meet all of our AS/400 experts

View all AS/400 questions and answers

Start the conversation

Send me notifications when other members comment.

Register

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close