Tools

<< Click to Display Table of Contents >>

Navigation:  User Interface > Ribbon Bar > Table >

Tools

Previous pageReturn to chapter overviewNext page

Show SQL

Shows the SQL query that was used for creating the current table.
You can modify that query manually and submit it by pressing OK button. Modifying of columns and tables is allowed only when you are connected to DB2 at z/OS.
Modified queries can be saved for later use by pressing Save As... button and loaded from the profile or a file by pressing Load... button.

 

clip0030

 

Show criteria

Shows the search criteria used for creating of the current table.
 

Inverse Filter

When this option is checked then the filters in the very first row of any table work in the inverse mode. That means, the table hides records matching the entered values.