Populating the SQL Outline view

You can populate the SQL Outline view from the System z® LPEX Editor, COBOL Editor, or PL/I Editor. In this view you can edit, run, and tune EXEC SQL statements.

Before you begin

You must add data access development support to your local z/OS® project or remote MVS™ subproject.

Procedure

  1. Open a COBOL or PL/I program that contains EXEC SQL statements with the System z LPEX Editor, COBOL Editor, or PL/I Editor.
  2. Right-click in the editor and select Extract SQL. The SQL Outline view opens and is populated with the SQL that is in the source file. If the source file contains copy or include files with EXEC SQL statements, then these statements are also placed in the outline view.

Results

In the SQL Outline view, you can select actions such as Open Query Tuner, Run SQL, and Open Visual Explain. If you double-click a query in the SQL Outline view, the editor is positioned at the line of source code that contains the query.

For more information about using the SQL Outline view, see the related topics.


Feedback