Sybase SQL Anywhere Studio 8.0.2 Read Me First Copyright (c) 1989-2002 Sybase, Inc. Portions Copyright (c) 2002, iAnywhere Solutions, Inc. All rights reserved. All unpublished rights reserved. Contents ======== Updated Components New Features in SQL Anywhere Studio 8.0.2 - UltraLite Component Suite - Adaptive Server Anywhere - MobiLink Synchronization - UltraLite Databases - SQL Remote Replication Behavior changes in SQL Anywhere Studio 8.0.2 - Supported platforms changes including Windows CE 2.11 not supported in this release. - Other changes Deprecated features Known issues and limitations Updated Components ================== The following components are included in this version of SQL Anywhere Studio: Adaptive Server Anywhere Version 8.0.2 UltraLite deployment option Version 8.0.2 MobiLink synchronization Version 8.0.2 SQL Remote replication Version 8.0.2 InfoMaker Version 8.0.1 (not updated from 8.0.1) Open Client/Open Server Version 12.5 (not updated from 8.0.1) PowerDesigner PhysicalArchitect Version 8.0.1 (not updated from 8.0.1) jConnect for JDBC Version 4.5 and 5.5, EBF 9689 (not updated from 8.0.1) Sybase Central Version 4.1.1 New Features in SQL Anywhere Studio 8.0.2 ========================================= This section is a summary of the more significant new features. For a complete description of the new features, see the links on the front page of the online books. UltraLite Component Suite ------------------------- UltraLite database technology can now be used from new development platforms in an easy-to-use fashion. The UltraLite Component Suite brings UltraLite technology to users of eMbedded Visual Basic, AppForge MobileVB, and Java. The component for Java is an alternative to the UltraLite for Java described in the UltraLite User's Guide. The component is not a 100% pure Java implementation, but instead uses native classes for better performance. Adaptive Server Anywhere ------------------------ You can create clustered indexes on a table. In a clustered index the rows are stored in approximately the same order as they appear in the index. Adaptive Server Anywhere supports unique identifiers (UUIDs and GUIDs). UUIDs (universally unique identifiers) and GUIDs (globally unique identifiers) are a mechanism for uniquely identifying rows, even across distinct databases in a synchronization environment. You can use the ON EXISTING clause of the INSERT statement to update existing rows with new values, as long as the table has a primary key. Adaptive Server Anywhere allows you to create image backups of databases operating on the Windows CE platform, or to rename or truncate the database's transaction log. The graphical plan has been enhanced to include more information, resulting in a new look. The use of work tables is now postponed until as late as possible in the plan. When work tables are used, they now appear explicitly in the graphical plan. New joins added to this release include the nested loops semijoin, the nested loops anti-semijoin, the hash semijoin and the hash anti-semijoin. You can obscure the logic contained in stored procedures, functions, triggers and views using the SET HIDDEN option. This allows applications and databases to be distributed without revealing the logic in stored procedures, functions, triggers, and views. MobiLink Synchronization ------------------------ MobiLink now supports Visual Studio .NET programming languages for writing synchronization scripts. A graphical tool, the MobiLink Monitor, has been introduced to allow you to see the time taken by every aspect of the synchronization, sorted by MobiLink user or by worker thread. You can now write Java and .NET code that executes at the time the MobiLink server starts the JVM or CLR, before the first synchronization. A new way to maintain unique primary keys on remote databases is introduced with Universally Unique IDs (UUIDs, also known as GUIDs). Two new client stored procedures, sp_hook_dbmlsync_download_ri_conflict and sp_hook_dbmlsync_download_log_ri_contlict, are introduced to help you manage referential integrity violations during download. You can now delete all the data in a remote table by including one row in the download_delete_cursor that has NULL in every primary-key column. A new dbmlsync command line option has been created, -urc, which allows you to improve synchronization performance by providing an estimate of the number of rows that will be uploaded. MobiLink now supports the HTTPS protocol. This new stream implements HTTP over SSL/TLS using RSA encryption, and is compatible with any other HTTPS server. MobiLink clients running on Pocket PC 2002 or Windows desktop computers can now connect through dial-up network connections. Using scheduling, your remote can synchronize unattended. The new synchronization stream parameters are network_name, network_connect_timeout, and network_leave_open. MobiLink now supports Web servers that support the Java servlet API 2.2, including Apache Tomcat. You can now use RSA encryption as well as the existing elliptical-curve encryption for synchronization security. The utilities gencert and readcert support the RSA certificates as well as elliptical-curve certificates. UltraLite databases ------------------- When deploying a new version of an application, you can now choose to upgrade the schema of UltraLite database to the schema of the new application. The UltraLite Java runtime is now thread-safe, enabling the development of multi-threaded UltraLite applications. UltraLite databases can now use the UNIQUEIDENTIFIER Adaptive Server Anywhere data type. This type is a BINARY(16) used for storing universally unique identifiers (UUIDs or GUIDs). UNIQUEIDENTIFIER columns that use the NEWID function as a default value can guarantee unique primary keys across a whole MobiLink installation, as an alternative to GLOBAL AUTOINCREMENT. Two new secure synchronization protocols are introduced in this release. HTTPS is HTTP implemented over a transport-layer security protocol, and RSA is a form of transport-layer security encryption used over HTTP or TCP/IP networks. To resynchronize previously downloaded data, for example to set an application to a clean state, you can reset the last download timestamp. SQL Remote Replication ---------------------- For improved troubleshooting of errors at remote sites, log information can be collected at the consolidated database. Behavior changes in SQL Anywhere 8.0.2 ====================================== This section is a summary of the more significant behavior changes. For a complete list of behavior changes, see "What's New in SQL Anywhere Studio->2. What's New in Version 8.0.2->Behavior changes in version 8.0.2" in the online books. Supported platforms changes --------------------------- The following platforms are not supported by this version of SQL Anywhere Studio: - Windows CE version 2.11 - Windows CE SH3 and SH4 chips - Windows CE PowerPC chips For full details of platform support, see "Introducing SQL Anywhere Studio->Appendix A: Supported Platforms" in the online books. In addition, UltraLite does not support VxWorks 5.5. OPTIMIZATION_GOAL setting changed --------------------------------- The default setting for the OPTIMIZATION_GOAL option is set to all-rows rather than first-row. This affects the execution plan chosen for some queries and so will change performance characteristics. Serial synchronization no longer supported ------------------------------------------ Serial synchronization was supported for UltraLite clients on the Palm OS. It is no longer supported as HotSync provides a recommended alternative. A consequence of this is that the DLL dbser8.dll is no longer included with the software. jConnect version ---------------- Recent EBF releases of SQL Anywhere Studio 8.0.1 have included a later version of jConnect (EBF 10636) than is included with this release (EBF 9689). It has been found that EBF 10636 introduces a problem with character set translation. We recommend that you uninstall EBF 10636 and use EBF 9689 instead. To install EBF 9689 (included with this software) over EBF 10636 you must delete the jConnect-4_5 and jConnect-5_5 directory trees from your Shared directory (default location c:\program files\sybase\shared on Windows) and then run Setup. Deprecated features =================== Support for the VxWorks operating system will be dropped in the next major release of SQL Anywhere Studio. Known issues ============ If you unload a plug-in from Sybase Central, you must shut down Sybase Central and restart it before the plug-in can be reloaded. The MobiLink Monitor provides an option to connect to the MobiLink server using HTTPS. You can use this option only if you have the separately licensable Security option, which provides Certicom security libraries, installed. If you select HTTPS without the Security option installed, the Monitor generates a stack trace. You can click OK on the stack trace window and choose another stream.