Running SQL statements in an editor

You can run an SQL statement from the editor.

For information about setting up Db2® for z/OS® Development tooling, see Developing with Db2 for z/OS.
Supported Editors:
  • COBOL Editor
  • PL/I Editor
  • z Systems® LPEX Editor

Procedure

  1. Open a COBOL or PL/I program that contains EXEC SQL statements.
  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 Developing with Db2 for z/OS.