What's New in SQL Anywhere Studio
What's New in Version 8.0.0
New features in version 8
Adaptive Server Anywhere new features
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 Welcome to SQL Anywhere Studio.
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
For more information, see Introducing 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 table values 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 Profiling database procedures.
For more information about obtaining procedure profiling information with SQL stored procedures, see sa_procedure_profile_summary system procedure and sa_procedure_profile system procedure.
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 access 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 Interactive SQL.
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.
For more information, see GRAPHICAL_ULPLAN function [Miscellaneous].
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 The Interactive SQL utility.