UNIQUEIDENTIFIER native data type   The UNIQUEIDENTIFIER data type is now a native data type rather than a domain defined on BINARY(16). As a result, Adaptive Server Anywhere automatically carries out type conversions as needed, so that the STRTOUUID and UUIDTOSTR conversion functions are not needed to handle UNIQUEIDENTIFIER values.

To use the UNIQUEIDENTIFIER data type in databases created before this release, you must upgrade the database file format by unloading and reloading the database.

See UNIQUEIDENTIFIER data type.

Conflict function for RESOLVE UPDATE triggers   The CONFLICT function can be used in conflict resolution triggers to determine if a particular column is a source of conflict for an UPDATE being performed on a SQL Remote consolidated database.

See CONFLICT function [Miscellaneous].

Procedure profiling enhancements    Profiling information can now be filtered per user and per connection using the sa_server_option stored procedure.

See Enabling profiling using sa_server_option and sa_server_option system procedure.

Remote servers can be tested before they are created or modified   The Create Remote Server wizard in Sybase Central has a Test Connection button that allows you to test whether the connection information supplied in the remote server definition allows you to connect successfully before the remote server is created.

The Remote Server properties window in Sybase Central also has a Test Connection button that allows you to test whether you can successfully connect to a remote server if its properties are changed.

See Creating remote servers using Sybase Central.

INPUT and OUTPUT statements accept the ESCAPES clause   The ESCAPES clause allows you to specify that characters are recognized and interpreted as special characters by the database server.

See INPUT statement [Interactive SQL] and OUTPUT statement [Interactive SQL].

WAITFOR can wake up when it receives a message from another connection   The WAITFOR statement can now wake up when it receives a message from another connection using the MESSAGE statement.

See WAITFOR statement.

Derived tables appear in execution plans   Derived tables now appear as nodes in query execution plans.

ALTER DOMAIN statement   The ALTER DOMAIN statement allows you to rename user-defined domains and data types.

See ALTER DOMAIN statement.

NO RESULT SET clause for procedures   Declaring a stored procedure NO RESULT SET can be used when external environments need to know that the stored procedure does not return a result set.

See CREATE PROCEDURE statement.

Column statistics updated during index creation   The CREATE INDEX statement now has the side effect that column statistics are updated for the indexed columns.

See CREATE INDEX statement.

PHP module   The SQL Anywhere PHP module allows access to Adaptive Server Anywhere databases from the PHP scripting language.

See SQL Anywhere PHP API.

Web service clients   In addition to acting as a web-service provider, Adaptive Server Anywhere can now act as a web-service client, making it possible to create stored procedures and stored functions that access Adaptive Server Anywhere web services, as well as standard web services available over the internet.

See SQL Anywhere web services.

Multiple web service formats supported   The format of the WSDL file provided by a DISH service, as well as that of data payloads returned of part of SOAP responses, can now be selected to best suit the needs of the client applications. You can now choose between DNET for Microsoft .NET, CONCRETE for clients that automatically generate interfaces, and a general-purpose XML format.

See Creating SOAP and DISH web services.

odbc_describe_binary_as_varbinary option   This option allows you to choose whether you want all BINARY and VARBINARY columns to be described to your application as BINARY or VARBINARY.

See odbc_describe_binary_as_varbinary [database].

New prefetch option value   The prefetch option now has an additional value of Always. This value means that cursor results are prefetched even for SENSITIVE cursor types and cursors that involve a proxy table.

See prefetch option [database].

db_locate_servers_ex function   This function provides programmatic access to the information displayed by the dblocate -n option, listing all the Adaptive Server Anywhere database servers on a specific host.

See db_locate_servers_ex function.

SNMP Agent   Adaptive Server Anywhere can now be monitored from Simple Network Management Protocol (SNMP) applications.

See The SQL Anywhere SNMP Extension Agent.

Deadlock reporting   You can now obtain information about connections involved in deadlock using a new database option, log_deadlocks, and a new system stored procedure, sa_report_deadlocks. When you turn on the log_deadlocks option, the database server records information about deadlocks in an internal buffer. You can obtain deadlock information from this internal buffer by calling sa_report_deadlocks.

See Determining who is blocked.

New collations   The following collations have been added in this release:

See Supported and alternate collations.

New Service utility (dbsvc) options   The Service utility (dbsvc) supports the following new options:

See Service utility (dbsvc) for Windows.

New Data Source (dbdsn) utility options   The Data Source utility (dbdsn) supports the following new options:

See Data Source utility (dbdsn).

Disk full callback support   The -fc database server option allows you to specify a DLL containing a callback function that can be used to notify users, and possibly take corrective action, when a file system full condition is encountered.

See -fc server option.

Validate Database wizard enhancements   When you validate a database using the Validate Database wizard in Sybase Central, the wizard indicates the current table being validated, as well as the overall progress of the validation operation. In addition, for databases with checksums enabled, you can validate both tables and checksums at the same time.

See Validating a database.

Unloading table data in Sybase Central   You can now unload data from one or more tables in Sybase Central in one step using the Unload Data window.

See Using the Unload Data window.

New columns added to sa_index_density and sa_index_levels   Three new columns have been added to the result sets returned by the sa_index_density and sa_index_levels stored procedures: TableId, IndexId, and IndexType. If you want to revert to the old behavior of these stored procedures, you can drop the stored procedure and recreate it with the columns that were included in the result set in previous versions of the software.

See sa_index_density system procedure and sa_index_levels system procedure.

HISTORY option for BACKUP and RESTORE DATABASE statements   The HISTORY option allows you to control whether BACKUP and RESTORE DATABASE operations are recorded in the backup.syb file.

See BACKUP statement and RESUME statement.

Support for integrated logins using Windows user groups   In addition to creating integrated logins for individual users on Windows NT/2000/XP, you can now create integrated login mappings to user groups on Windows NT/2000/XP. It is recommended that you upgrade your database before using this feature.

See Creating integrated logins for Windows user groups.

Managing the size of the request log   The -zn database server option allows you to specify how many request log files should be retained.

See -zn server option.

Free pages at the end of the transaction log are removed when the file is renamed by a backup   Transaction log files are grown in fixed-size increments for better performance. When the transaction log is renamed as part of a backup, the free pages at the end of the log are removed, which helps free up disk space.

Remote server connections can now be explicitly closed   In previous releases, connections from Adaptive Server Anywhere to remote servers were disconnected only when a user disconnected from Adaptive Server Anywhere. You can now explicitly disconnect Adaptive Server Anywhere from a remote server using the new CONNECTION CLOSE clause of the ALTER SERVER statement.

See ALTER SERVER statement.

Initialization files can be obfuscated with dbfhide   The File Hiding utility (dbfhide) can now be used to obfuscate the contents of .ini files used by Adaptive Server Anywhere and its utilities.

See File Hiding utility (dbfhide).

FIPS-certified security   On all supported Windows platforms except Windows CE, you can now use secure communication with FIPS 140-2 certified software from Certicom.

See Starting the database server with transport-layer security.

Strong database encryption using FIPS140-2 certified software from Certicom is also available on supported 32-bit Windows platforms.

See Encrypting a database.

New connection properties   The following connection properties have been added:

See Connection-level properties.

Proper formatting Event Viewer messages   When deploying Adaptive Server Anywhere databases, you should set a registry entry that controls the formatting of messages in the event viewer.

See Deploying database servers.

log_deadlocks option   This option allows you to control whether the database server logs information about deadlocks in an internal buffer. This option can be used with the sa_report_deadlocks procedure to obtain information about deadlock.

See log_deadlocks option [database].

rollback_on_deadlock option   This option allows you to control whether a transaction is automatically rolled back if it encounters a deadlock.

See rollback_on_deadlock [database].

temp_space_limit_check option   This option allows you to control what happens when a connection requests more than its quota of temporary file space.

See temp_space_limit_check option [database].

New system stored procedures   Several new system stored procedures have been added:

Maximum cache size on Windows CE   In previous releases of SQL Anywhere Studio, the maximum cache size on Windows CE was 32 MB. This limit has been removed and the cache size is now limited by the amount of available memory on the device.

New database server options for UNIX   The following database server options have been added for UNIX: