Executing an IMS SQL Statement

Execute an IMS SQL statement using the IMS SQL Editor.

Prerequisites 

Ensure the IMS Database Manager Host Connection that will be used is connected. Open the SQL file in the IMS SQL Editor and select the Host Connection.

  1. Highlight the SQL statements you wish to execute.
  2. Execute one, multiple, or all SQL statements.
    Desired result Required action
    Execute one or more SQL statements Highlight the statements and select Execute Selected Text.
    Execute all statements Select Execute All.

    Execution status and and results appear in the SQL Results view.

Related tasks
Viewing IMS SQL Results