IBM IMS Explorer for VS Code

Creating IMS Projects

Overview

IMS Explorer for VS Code allows you to create IMS projects to organize and execute SQL queries against IMS databases. Use the following steps to create IMS projects in the IMS Projects view and how to create and edit SQL within those projects.

Step 1: Open the IMS Projects View

  1. In Visual Studio Code, open the IMS Projects view from the Activity Bar.

This view allows you to create, edit, and organize SQL project files used with IMS databases.

Step 2: Create a New IMS Project

  1. In the IMS Projects view, click Create Project.
  2. Provide a project name when prompted.

The project appears in the view. You can create multiple projects to manage SQL files.

Step 3: Create SQL Files in the Project

  1. Right-click the new project and select New SQL File.
  2. Enter a name for your SQL file.

The file opens in the editor, where you can structure SQL queries.

Step 4: Edit SQL for IMS Databases

  1. Open any SQL file in the project.
  2. Write or edit SQL statements to be executed against IMS databases. SQL syntax highlighting and validation are provided by the IMS Explorer extension.

Step 5: Execute SQL Against an IMS Connection

  1. Ensure you have created an IMS database connection in the IMS Connections view.
  2. Select the IMS database connection you wish to execute the SQL query on in the status bar or by using the IMS Connections view.
  3. Run SQL directly from the SQL editor using the Run button at the top-right of the editor window.
  4. Query results appear in a results view where you can sort, filter, and download rows as CSV.

Executing SQL requires an IMS database connection, to create a connection see Creating IMS Connections.