Automatically release database locks   The database server creates schema locks on tables that you view in Interactive SQL, even if you do not modify the table.

However, now Interactive SQL attempts to release the database schema locks it creates when it displays your result set.

After you execute a statement that returns a result set, Interactive SQL checks if your connection has any uncommitted changes in the database. If none exist, then Interactive SQL releases your schema locks; otherwise, Interactive SQL does not release your schema locks. That is, Interactive SQL does not release your schema locks if you have any uncommitted changes to the database.

Support for read-only result sets   You can now make result sets read-only in Interactive SQL. To do this, choose Options » Results, and then select the Disable Editing option. This setting applies to subsequently fetched results. See Editing table values from the Interactive SQL result set.

When deploying Interactive SQL, you can prevent users from changing this setting by adding disableResultSetEditing to the entry for lockedPreferences in the OEM.ini file. See Configuring the administration tools.

Execute SQL statements one statement at a time   Previously, if you wanted to execute SQL statements one at a time, you repeatedly selected the SQL statement and ran Execute Selection. Now you can run Single Step to execute the selected statement and to select the next statement for execution. Similar to Execute Selection, Single Step is available from the SQL menu in Interactive SQL. See Executing SQL statements from Interactive SQL.

SQL file and database connection favorites   You can now create and maintain a list of favorite database connections and a list of favorite SQL command files with the Favorites menu in Interactive SQL. See Using favorites.

Disable table editing of result sets   When deploying Interactive SQL, you can now disable table editing of SQL Anywhere and UltraLite result sets in Interactive SQL. See Configuring the administration tools.

New keyboard shortcuts   New keyboard shortcuts have been added to Interactive SQL. See Interactive SQL keyboard shortcuts.

Support for preventing option changes in client applications   You can now prevent users from changing some of the Interactive SQL option settings by locking the settings in the OEM.ini file. See Configuring the administration tools.

New -version option for dbisql   From the command prompt, type dbisql -version to see the version number of Interactive SQL. See Interactive SQL utility (dbisql) and Interactive SQL utility for UltraLite (dbisql).