IMS SQL File Preferences

IMS SQL file preferences define the behavior of IMS SQL files in the IMS SQL Editor.

Table 1. SQL Files/Scrapbooks preferences
Field Description
Default Connection Information for New SQL Files Select a connection type, connection profile name, and database to use by default in new IMS SQL Editor sessions.
Connection Commit Mode
  • Select Auto (default) to automatically commit your changes to the database. Auto treats every SQL statement as a complete transaction. You cannot roll back changes. Auto commit mode works well for query-only applications.
Related concepts
IMS SQL Editor
Related tasks
Creating an IMS SQL File
Editing 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 Syntax Coloring Preferences
IMS SQL Templates Preferences