Instead of remembering SQL, you can easily add a link to the Tables page to look up dependency information.

The pages in the Technology Explorer for DB2 are defined in XML profiles. Each page has it's own XML profile stored within the web server. The file displayed to the right is the XML definition for the Tables page. The XML file controls the SQL to run, how the columns are displayed, cross reference links, and actions. It even controls detailed information on the page itself, searching rules, how many rows to display, and much more.

Goal:

Add a reference within the Table page's XML table definition file. You can use the modified file displayed to the right as an example.

Steps to complete:

The changes are indicated with the following: