SQL Outline view

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:

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 Data Access Development > Refresh Project in SQL Outline.

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.

Feedback