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, 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).
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|