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.
The workbench
refreshes the content of the SQL Outline view automatically when you
perform any of these actions:
- Add support for pureQuery to a Java project
- The workbench adds the project to the SQL Outline view and refreshes
all of the objects in the view.
- Remove support for pureQuery from a Java project
- The workbench removes the project from the SQL Outline view and
refreshes all of the objects in the view.
- Close a Java project that
supports pureQuery
- The workbench removes the project from the SQL Outline view and
refreshes all of the objects in the view.
- Open a Java project that
supports pureQuery
- The workbench adds the project to the SQL Outline view and refreshes
all of the objects in the view.
- Change the default schema, the default path, or both for a Java project or source file for
which the primary type is an annotated-method interface
- The workbench refreshes all of the objects in the view.
- Import a Java project that
supports pureQuery into your workspace
- The workbench adds the project to the SQL Outline view and refreshes
all of the objects in the view.
You can manually refresh the objects that the view
shows for a single Java project
by right-clicking the project and selecting .
Note: In
the Java Tab, the same SQL statement
can appear multiple times if the special register information captured
with the statement is different. For DB2 databases,
pureQuery Runtime captures special register values for each statement
captured. The special register information is displayed as properties
for the statement.