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

SQL Anywhere 12.0.0 » SQL Anywhere 12 - Changes and Upgrading » What's new in version 10.0.0 » Sybase Central and Interactive SQL


Behavior changes and deprecated features

Following is a list of changes to Sybase Central and Interactive SQL introduced in version 10.0.0.

  • Interactive SQL no longer sets the quoted_identifier option to On   In previous versions of the software, Interactive SQL set the quoted_identifier option to On. It now uses the database's setting for this option (by default, this option is set to On). See quoted_identifier option.

  • isql_plan option no longer supports the NONE parameter   The NONE parameter is no longer supported by the isql_plan option.

  • Interactive SQL can return unlimited result sets   In previous versions of the software, if you executed a query that returned multiple result sets, Interactive SQL only displayed a maximum of 10 result sets. Now Interactive SQL displays all result sets returned by the query. See isql_show_multiple_result_sets [Interactive SQL].

  • Interactive -f option behavior change   When starting Interactive SQL with the -f option, a connection is not made to a database automatically. Previously, a connection was opened automatically.

  • Accessing and saving graphical plans in Interactive SQL  

    • Two new menu choices, Open Plan and Save Plan, are available from the File menu in Interactive SQL for opening and saving graphical plans (previously this was done using the same Open and Save menu items as you used for opening and saving the SQL statements.

    • Previously, graphical plans were saved with an .xml file extension. Now, they are saved with the extension .saplan. However, the previous .xml file extension is still supported for displaying graphical plans that were stored with that extension.

    • In the Options window, you can now make Interactive SQL the default editor for both .sql and .saplan (graphical plan) files.

  • SET OPTION statement PUBLIC keyword deprecated   The PUBLIC keyword is deprecated for setting Interactive SQL options using the SET OPTION statement. See Interactive SQL options.

  • EXIT statement now closes the current Interactive SQL window   In previous releases, executing an EXIT statement from Interactive SQL closed all the Interactive SQL windows. Now, only window where the statement is executed is closed. See EXIT statement [Interactive SQL].

  • New error code for SQLE_ENGINE_NOT_MULTIUSER   Applications that were programmed to handle SQLE_ENGINE_NOT_MULTIUSER now need to check for a new error code. Previously, if an application attempted a write operation on the database while another thread was sending an upload to MobiLink, the runtime would return SQLE_ENGINE_NOT_MULTIUSER. Now the runtime will return a new, more accurate error code: SQLE_ULTRALITE_WRITE_ACCESS_DENIED. See Write access was denied.

  • Sybase Central plug-in Utilities tabs removed   The Utilities tabs in the SQL Anywhere, MobiLink, and UltraLite plug-ins have been replaced with a Tools button. You can also access utilities from the Sybase Central Tools menu.

 Deprecated and discontinued features