Pages in the SQL Outline view

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

Feedback