Editing an IMS SQL File

Edit the SQL statements in an IMS SQL file.

  1. In the Project Explorer view, double-click the SQL file to open it in IMS SQL Editor.
  2. (Optional) Change the connection profile Type, Name, and/or Database.

    Associating an SQL file with a connected IMS database Host Connection profile enables you to use the full capabilities of Content Assist and to execute the SQL file or selected statements.

  3. (Optional) Right-click in the left margin and select Show Line Numbers.
  4. Edit the SQL file by manually editing the SQL code.
  5. (Optional) Remove edits since your last save by right-clicking and selecting Revert File.
  6. Save the file to the project or to a new project.
Related concepts
IMS SQL Editor
Related tasks
Creating an IMS SQL File
Opening an IMS SQL File
Saving an IMS SQL File
Related reference
IMS SQL Editor Preferences
IMS SQL Code Assist Preferences
IMS SQL File Preferences
IMS SQL Syntax Coloring Preferences
IMS SQL Templates Preferences