Before you begin
Depending on your
license configuration, this functionality might not be available.
The SQL Outline view is populated when at least one of the following
items exists in a Java™ project
in your workspace:
- An interface that declares an annotated method that uses the pureQuery
API
- A pureQueryXML file that contains captured SQL statements
About this task
The SQL Outline
view lists the DB2® packages
and the Java source files that
contain the SQL statements. The view also shows the database objects
that the SQL statements reference.
To reduce the number of database
objects that are shown in the SQL Outline view, you can filter by
either or both of the following conditions:
- A database object name; that is, a schema name, a table name,
or a column name
- The SQL statements that reference the database objects
To filter by SQL statements, you provide an SQL text filter
pattern, which can contain SQL keywords, predicates, routine names,
and other text. The SQL text filter pattern must be specified in the
form of a regular expression whose syntax conforms to the Java Pattern class