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.