Accessibility features SQL Anywhere Studio is compliant with Section 508 of the US Federal Rehabilitation Act. The user interfaces and documentation have been prepared in compliance with the act. An accessibility enablement component provides software that enables the use of accessibility tools. The accessibility enablement component is not installed by default.
For more information, see SQL Anywhere 10 components.
Query Editor A graphical query editor has been added to Interactive SQL. With the Query Editor, you can create or edit SELECT statements without using SQL code. You can open the Query Editor in Interactive SQL by clicking Tools > Edit Query.
For more information, see Introduction to the Query Editor.
Editable data in Interactive SQL and Sybase Central You can update the database by editing Interactive SQL result sets, and by editing tables and views in Sybase Central. You can copy, edit, insert, and delete row values.
Data displayed in Sybase Central can be copied to the clipboard.
For more information, see Editing result sets in Interactive SQL.
Interactive SQL supports SQL escape syntax handling Interactive SQL now supports JDBC escape syntax that allows you to access a library of functions implemented by the JDBC driver.
For more information, see Using JDBC escape syntax.
Procedure profiling Sybase Central contains a Profile tab that displays information about the number of calls and execution times for stored procedures, functions, events, and triggers. You can also view information about the execution speed for each line within a procedure. Profiling information is available through Sybase Central and SQL stored procedures.
For more information about viewing procedure profiling information in Sybase Central, see Procedure profiling using system procedures.
To use this feature, you must upgrade the database.
Improved information for access plans There are two new ways to view the plan, a graphical display and a graphical display with statistics. These new plans provide more information about the processing cost of your query, and allow you to examine the cost of subsets of the query. The default access plan is now the graphical plan. The long and short plans are now based on the Ariadne syntax used by Adaptive Server Enterprise, and have new abbreviations.
For more information, see Reading execution plans.
Results pane displays query execution plan The Interactive SQL Results pane now has a Results tab. The Results tab displays the results of your query, and the Plan tab displays the execution plan for the query. Previously, the query execution plan appeared in the Interactive SQL Messages pane.
For more information, see Options dialog: Results tab.
Results pane displays UltraLite plan The Interactive SQL Results pane now has an UltraLite Plan tab. This tab displays the UltraLite plan optimization strategy in XML format, as a string.
XML export using the OUTPUT statement You can export query results as XML format. The output has an embedded DTD. Binary values are encoded in CDATA blocks with the binary data rendered as two-hexadecimal-digit strings.
For more information, see OUTPUT statement [Interactive SQL].
Interactive SQL batch options Additional control is given to Interactive SQL when running batch files, through the -codepage and -onerror command line options. Also, the -d1 command line option provides feedback useful for debugging batch files.
For more information, see Interactive SQL utility (dbisql).