		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.

