For all of
the open projects in your workspace that have support for Data Access
Development enabled, the SQL Outline view lists 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. For projects that
have pureQuery support enabled, you can bind DB2® packages. The Data Source Explorer shows
where packages are in the database.
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.