The SQL Outline
view contains three pages that let you view the relationships between DB2® packages, Java™ files, and SQL statements 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 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 pureQuery)
- 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 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 pureQuery)
- 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