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

SQL Anywhere 11.0.0 » SQL Anywhere 11 - Changes and Upgrading » What's new in version 8.0.0 » New features in version 8 » Adaptive Server Anywhere new features


Development and administration tools

  • 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 11 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.

  • 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.

    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 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.

  • 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).