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

Published: 01 May 2008

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

Free Outlook add-on a must in the developer's toolbox Whether you're a Outlook development newbie or a seasoned extended MAPI whiz, this free tool shows you the nuts and bolts of MAPI and gives you access to Outlook Object Model objects.

SQL Server tools take the time out of database searches Searching databases for specific objects can be frustrating – especially when you can’t recall exactly where said objects are. Fortunately, there are tools out there that can help.

Five signs you need to replace your data backup software Here's how you can take an objective look at your backup software and determine if it's time to replace it.

DAYSPAST CLLE program for AS/400: Compares object creation date with today's date A CLLE program for AS/400 to determine the number of days that have passed since an object was created.

Tracking a deleted Active Directory object's replication status Learn how to track a deleted Active Directory object's replication status and how to determine if the object has been replicated throughout the DC forest.

Find size of SQL Server tables and other objects with stored procedure When determining SQL Server disk space used by an object, Microsoft's sp_spaceused has limits. Here's an original stored procedure, sp_SOS, that calculates specific object space in SQL Server. Use it to get an overview of user table sizes in a database, the summary of the total space owned by a group of tables and to see the top 10 biggest indexed objects.

Related Q&A from Kent Milligan

SQL server error message -321

To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... Continue Reading

Choose which column names are returned via ODBC when working with DB2 files

When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ... Continue Reading

Developing tables in a parent-child relationship in DB2

When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to ... Continue Reading

Have a question for an expert?

Please add a title for your question

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

Meet all of our AS/400 experts

View all AS/400 questions and answers

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

Dig Deeper on iSeries SQL commands and statements

Related Q&A from Kent Milligan

SQL server error message -321

Choose which column names are returned via ODBC when working with DB2 files

Developing tables in a parent-child relationship in DB2

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Refresh your data center cooling lexicon

Comparing Linux distributions: Red Hat vs. Ubuntu

Get eco-friendly with LEED data center certification

Dig Deeper on iSeries SQL commands and statements

Related Q&A from Kent Milligan

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.