For all of
the open projects in your workspace that have support for pureQuery
enabled, the SQL Outline view lists the DB2® packages
and the Java source files in
which the SQL statements in your application are located. The view
also shows the database objects that the SQL statements reference. You can use this
view to find out the following information about the SQL statements
that are in your application:
- Proposed DB2 packages and
actual DB2 packages
- The Java files that contain
the SQL statements and the location of the statements within those
files
- The database objects that are accessed by the SQL statements
You can also see properties of DB2 packages,
SQL statements, and Java files
that you select.
To open this view, select Window > Show
View > Other. In the Show
View window, expand the Data Management folder
and select SQL Outline. Then, click OK.
There are two ways
to refresh the content of this view:
- Use the Refresh project in outline button
(
) when you have modified the content
of a project and want the changes reflected in the view.
- Use the Refresh with projects in workspace button
(
) if you close
or open projects in your workspace, or add or remove pureQuery support
to or from projects.