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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Changes and Upgrading » What's New in Version 10.0.1 » SQL Anywhere

SQL Anywhere Next Page

New features


Following is a list of additions to SQL Anywhere databases and database servers introduced in version 10.0.1.

Encryption enhancements

The following changes have been made to enhance support for encryption.

Support for client statement caching

Client statement caching is now supported and enabled by default, so that when the same SQL text is prepared and dropped repeatedly, the client caches the statement, leaving it prepared on the server after it has been dropped by the application. This saves the database server the extra work of dropping and re-preparing the statement. Both a version 10.0.1 client library and a version 10.0.1 database server are required to use client statement caching.

The following changes have been made to provide support for client statement caching.

SQL Flagger enhancements

The SQL Flagger feature has been enhanced to allow better detection of compatibility, and to add support for newer standards. For example, you can now test compatibility with a specific SQL standard, or compatibility with UltraLite SQL.

To support these enhancements, the following changes have been made:

SQL statements

The following enhancements have been made to SQL statements and functions.

Support for collation tailoring

SQL Anywhere now supports collation tailoring when creating a database. The following changes have been made to support collation tailoring:

Enhancements to web services

The following enhancements have been made to improve the configurability of HTTP and SOAP headers:

Enhancements to database mirroring

The following enhancements have been added to the database mirroring feature:

SQL Anywhere plug-in
Miscellaneous enhancements