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.
-
Highlight the SQL
statements you wish to execute.
-
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.