Tuning SQL statements in an editor

You can open the query tuner from the System z® LPEX Editor, COBOL Editor, or PL/I Editor.

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. 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.

Feedback