The dependencies display from the last step uses a default XML profile.
We can improve it's appearance and function by creating a custom profile.
Fortunately, you don't have to start with a blank file.
Whenever the Technology Explorer for DB2 deals with a table that doesn't have a profile, it creates a default using
the pureXML capabilities built into the DB2 data server.
(That is how it can display the contents of any table in the Tables page.)
To create a default that you can edit, select the XML reference column in the table catalog view of the Technology Explorer.
Goal:
Find the 'SYSCAT.TABDEP' table and save the XML table definition file associated with it.
Steps to complete:
- On the menu bar of the table page to the right
- Select 'Schema' from the 'Column' drop down
- Select '=' from the 'Condition' drop down
- Select 'SYSCAT' from the drop down
- Click on the 'Add condition' button
- Select 'Table' from the 'Column' drop down
- Select '=' from the 'Condition' drop down
- Enter in the value 'TABDEP' in the right hand field (case is sensitive)
- Click the 'Apply search' button
- If you do not see the table try searching again
- Click the icon in the XML column
- Right-click in the XML document and select 'This Frame' -> 'Save Frame As...'
- Navigate to the folder /var/www/tableDefinitions/
- Save the file with the name 'tableDependCat.xml' (case is sensitive)