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

SQL Anywhere 11.0.0 » SQL Anywhere 11 - 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.

  • 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).