Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere 12 - Changes and Upgrading » What's new in version 11.0.0 » Sybase Central and Interactive SQL » Sybase Central and Interactive SQL new features

 

Interactive SQL new features

Following is a list of additions to Interactive SQL introduced in version 11.0.0.

  • 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, click Options » Results, and then click 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 Administration tools configuration.

  • 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 clicked Execute Selection. Now you can click 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 in 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 script files with the Favorites menu in Interactive SQL. See Saving SQL script files and connections in a favorites list .

  • 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 Administration tools configuration.

  • New keyboard shortcuts   New keyboard shortcuts have been added to Interactive SQL. See Keyboard shortcuts for Interactive SQL.

  • 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 Administration tools configuration.

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