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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere 11 - Changes and Upgrading » What's new in version 11.0.1 » Administration tool behavior changes and deprecated features

 

Interactive SQL behavior changes and deprecated features

Following is a list of changes to Interactive SQL introduced in version 11.0.1.

  • Configure the automatic release of database locks   Now, you can configure Interactive SQL to attempt to release the database schema locks it creates when it displays your result set. To do so, in Interactive SQL, choose Tools » Options » SQL Anywhere, and select Automatically Release Database Locks.

    When this option is selected, 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.