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

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.

Dig Deeper on iSeries SQL commands and statements

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchDataCenter

Close