Create a Customized 'Master View' Table Definition from an SQL Query
With the query in the top right panel we are going to generate a base table definition to expand upon later in this lab.
Steps:
- Run the query. You should see a result set appear after the query has been run.
- View the table definition XML for this query by clicking on 'Generate table definition XML' in the upper right corner of the result set. This will open a new tab to the right of this text in which the XML will be displayed
- Save the table definition XML. On Firefox, this would be by right-clicking in the XML document and then selecting 'This Frame' -> 'Save Frame As...'
- Save the file as 'db2authCustomMasterView.xml' in the folder '[your_TE_folder]/tableDefinitions/db2authLab'