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.
The workbench
refreshes the content of the SQL Outline view automatically when you
perform any of these actions:
- Add support for Data Access Development 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 Data Access Development from a Java project
- The workbench removes the project from the SQL Outline view and
refreshes all of the objects in the view.
- Add support for pureQuery to a Java project
- The workbench refreshes all of the objects in the view.
- Remove support for pureQuery from a Java project
- The workbench refreshes all of the objects in the view.
- Close a Java project that
supports Data Access Development or 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 Data Access Development or 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 Data Access Development or 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.