Running SQL statements in an editor

You can run an SQL statement 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 Run SQL. If the SQL statement contains host variables or parameter markers, a window opens that prompts you for the variable values.
  3. Specify variable values and click Finish. The query runs and the results are displayed in the SQL Results view. For more information about this view, see the related topics.

Feedback