Implementation workflow of an SQL query to IMS

Use IMS Explorer for Development to safely update the IMS catalog with your application.

1. Create an IMS Explorer Project, or alternatively, create a general project with the following steps:
   1. From the main menu, click File>New>Project.
   2. Select General>Project.
   3. Enter a Project name.
   4. Click Finish.
2. Create an IMS SQL file.

   In the SQL script, specify the SQL query statements to run against the IMS database.

   1. In the Project Explorer view, right-click the project that you created in step 1.
   2. Click New > Other…
   3. Click IMS Explorer > IMS SQL File
   4. Click Next.
   5. Type the name of the file in the File name field.
   6. Click Finish.

   The new SQL file will be automatically opened for editing.

3. Write and execute SQL script:
   1. In the Connection Profile area of the SQL editor, select the existing connection profile from the drop down Name menu.

      Note: The Database name will be automatically selected. The database name is specified when the connection profile is created.

   2. Enter SQL statements in the text editor area. Multiple SQL statements are separated by semicolon.
4. To view the results in the SQL Results view:
   1. Right-click anywhere in the text editor containing SQL script
   2. Select Execute All to execute the script.