Interactive SQL behavior changes and deprecated features

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

Graphical plans are now viewable in a Plan Viewer You now view graphical plans for SQL Anywhere databases in a separate, resizable window called the Plan Viewer, in Interactive
SQL. This change makes it easier to view and compare plans because you can now open multiple Plan Viewer windows at the same
time. To access the Plan Viewer, select Tools » Plan Viewer. Text plans for UltraLite databases are also displayed in the Plan Viewer. See Viewing plans using the Interactive SQL Plan Viewer.

In addition the Interactive SQL option isql_plan option is unsupported.

Support for viewing long and short plans has been removed You can no longer view text plans for SQL Anywhere databases in Interactive SQL. However, you can still retrieve them using
the EXPLANATION and PLAN functions. You can still view text plans for UltraLite databases using the Plan Viewer in Interactive
SQL.

Printing execution plans and result sets Now you can print the contents of the SQL Statements pane and the result sets by pressing Ctrl+P or by choosing Print from the File menu. Previously you could only print the contents of the SQL Statements pane. You can print in the Plan Viewer by pressing the Print button. See Printing SQL statements, execution plans, and result sets.

Line numbers added to the SQL Statements pane Line numbers are now visible on the left side of the SQL Statements pane. These line numbers can help you identify the location of syntax errors.

Enhancement to the Execute SQL Statements toolbar button Previously, on the Interactive SQL toolbar, the Execute SQL Statements button executed all SQL statements. Now you can specify whether to execute all statements, or to execute only the selected
statements when the button is clicked.

Interactive SQL provides improved feedback when executing batches of statements. When executing SQL statements from the SQL Statements pane, the statement being executed is now selected and scrolled into view. When executing script files via File » Run Script, a status window appears which shows the progress through the script. See Executing multiple SQL statements.

Enhancements to the Results pane

In the Results pane, you can now select all the results by pressing Ctrl+A. You can also select the entire result set, not just the currently
fetched results. When the Results pane does not contain the entire result set, you are prompted to fetch the remaining results. Otherwise, only the currently
fetched results are selected.

Now when you copy cells from the Results tab the copied data is formatted based on the following Interactive SQL options: isql_field_separator, isql_quote, and isql_escape_character.
You can also copy to the clipboard selected values, rows, and columns from the result set. See Copying rows from an Interactive SQL result set.

Now when you click a column-header in the Results tab, the results are sorted by that column. When the Results pane does not contain the entire result set, you are prompted to fetch the remaining results. Otherwise, only the currently
fetched results are sorted.

Generate » INSERT Statement Generates an INSERT statement for each selected row and copies them to the clipboard.

Generate » DELETE Statement Generates a DELETE statement for each selected row and copies them to the clipboard.

Generate » UPDATE Statement Generates an UPDATE statement for each selected row and copies them to the clipboard. The generated statements set the column
values to their current values. Consequently, executing the statements would not actually change the column values. This functionality
can be useful for providing a template UPDATE statement which you could edit before executing it.

Supported formats for the INPUT statement have changed The INPUT statement no longer supports the dBase, Lotus, Excel, and FoxPro file formats. TEXT and FIXED are still supported.
If you want to continue to use these file formats, you will have to do so via an ODBC driver. See INPUT statement [Interactive SQL].

Supported formats for the OUTPUT statement have changed The OUTPUT statement no longer supports the dBase, Lotus, Excel, and FoxPro file formats. TEXT, FIXED, HTML, SQL, and XML
are still supported. See OUTPUT statement [Interactive SQL].

ASCII format is renamed TEXT for INPUT and OUTPUT statements INPUT and OUTPUT statements now use TEXT. Use of ASCII is still supported; however, for backward compatibility.

Changes to the Import Wizard and the Export WizardWhen the Import Wizard or the Export Wizard finishes, the SQL statement generated by the wizard is stored in the command history. To view the generated SQL Statement,
choose SQL » History.

SET OPTION statement PUBLIC keyword removed Support for the PUBLIC keyword is removed for setting Interactive SQL options using the SET OPTION statement. See Interactive SQL options.

Changes to the Interactive SQL launcher Previously, the Windows version of the Interactive SQL launcher executable was named dbisqlg.exe and the command line version was named dbisql.exe. Now, the Windows version of Interactive SQL is dbisql.exe and the command line version is dbisql.com.