When the Scanned SQL Viewer window is first opened all SQL statements in the selected Job are shown. Customization of the view allows the displaying of: All, Simple, Problematic, Complex, and/or Invalid SQL statements. In addition, you can view the Checked and/or Unchecked SQL statements. The title bar of the Scanned SQL Viewer window displays the chosen criteria. One or more types of SQL statements can be viewed by selecting or de-selecting the menu items. The Job list contains all the Jobs using the chosen view criteria:

To display all SQL statements

Select View | All SQL.

To display the Simple SQL statements

Select View | Simple SQL.

To display the Problematic SQL statements

Select View | Problematic SQL.

To display the Complex SQL statements

Select View | Complex SQL.

To display the invalid SQL statements

Select View | Invalid SQL.

 

To display SQL statements with different bound and new access plan that satisfy the selected SQL classification type

Select View | Different Bound and New Access Plan.

To display SQL statements with no bound access plan that satisfy the selected SQL classification type

Select View | No Bound Access Plan.

 

To displays all Checked SQL statements

Select View | Checked SQL.

To displays all Unchecked SQL statements

Select View | Unchecked SQL.