Tuning SQL statements in an editor

You can open the query tuner from the editor.

Before you begin

Supported Editors:
  • COBOL Editor
  • PL/I Editor
  • z Systems® LPEX Editor
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.
  2. Highlight an EXEC SQL statement, right-click, and select Tune Query.
    The Query Tuner Workflow Assistant opens. For more information about this view, see the related topics.