The SQL Outline
view contains three pages that let you view the relationships between
SQL statements, Java files,
and DB2® packages in different
ways. Click the tabs at the bottom of the view to see the different
pages. The following
list describes the three pages and the hierarchy of objects that each
page displays. Objects from open projects in your workspace that have
support for Data Access Development enabled or support for pureQuery
enabled appear on each page.
- Database page
- Use this page to see the information in the view grouped under
the schema of the database objects that the SQL statements refer to.
- This page shows objects in the following hierarchy:
- Database schema in which the database object that SQL statements
refer to are located
- Database object that SQL statements refer to
- SQL statement
- Project (open and enabled with support for Data Access Development)
- Java file in which the SQL
statement is located
- Columns that the SQL statement references
- Database packages page
- Use this page to see the information in the view grouped under
packages. This page displays information only if or more open Java
projects in the workspace are enabled with pureQuery support.
- This page shows objects in the following hierarchy:
- DB2 package
- SQL statement
- Project (open and enabled with support for pureQuery)
- Java file
- Schema of the SQL statement
- Database object that is referenced by the SQL statement
- Columns that are referenced by the SQL statement
- Java page
- Use this page to see the information in the view grouped under
the Java packages for the source
files in which the captured SQL statements appear.
- This page shows objects in the following hierarchy:
- Project (open and enabled with support for Data Access Development)
- Java package
- Java file
- SQL statement
- Schema of SQL statement
- Database object that is referenced by the SQL statement
- Columns that are referenced by the SQL statement
- Line number where the statement is prepared
- Line number where the statement is run
- Replacement statement, if the original SQL statement is in a pureQueryXML
file and you added a replacement statement when editing that file