Following is a list of additions to Interactive SQL introduced in version 11.0.0.
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).
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|