PowerBuilder 10.5

Sybase SQL Anywhere Studio 9.0.2 Read Me First Copyright (c) 1989-2004 Sybase, Inc. Portions Copyright (c) 2002-2004, iAnywhere Solutions, Inc. All rights reserved. All unpublished rights reserved. Contents ======== 1. Updated Components and Upgrade Information 2. New Features in version 9.0.2 - Adaptive Server Anywhere Databases - MobiLink Synchronization - UltraLite Databases - QAnywhere Messaging 3. Behavior changes in version 9.0.2 - Adaptive Server Anywhere Databases - MobiLink Synchronization - UltraLite Databases - QAnywhere Messaging 4. Known issues and limitations - Install issue on Windows 95 - Native UltraLite for Java and the CrEme VM - Notes for users of new PalmOne devices - QAnywhere Agent does not work with encrypted communications - QAnywhere agent ID on Windows operating systems - Additional MobiLink user ID for QAnywhere agents - QAnywhere TestMessage sample limitations - QAnywhere failover capability - Batch file change in ASA samples - Upgrading a QAnywhere message store from 9.0.1 to 9.0.2 ***************************************************************************** ** For documentation corrections, see the errata file docs\errata_sas.txt, ** ** accessible from documentation front page. ** ***************************************************************************** 1. Updated Components and Upgrade Note ======================================= Updated Components ------------------ The following components are included in this version of SQL Anywhere Studio: Adaptive Server Anywhere Version 9.0.2 UltraLite Version 9.0.2 MobiLink synchronization Version 9.0.2 SQL Remote replication Version 9.0.2 InfoMaker Version 9.0.0 (not updated from 9.0.1) Open Client/Open Server Version 12.5 (not updated from 9.0.1) PowerDesigner PhysicalArchitect Version 9.5.2 (not updated from 9.0.1) jConnect for JDBC Version 4.5 and 5.5, EBF 9689 (not updated from 9.0.1) Sybase Central Version 4.3 Upgrade information ------------------- If you upgrade a version 8 Adaptive Server Anywhere database by unloading and reloading the database, and if the database is in use as a MobiLink consolidated database, you must ensure that you use the version 9.0.2 unload utility (dbunload), not the version 8 unload utility. If you use the version 8 unload utility, the attempt will fail because of schema differences in the Mobilink catalog tables between 8.x and 9.x databases. 2. New features in version 9.0.2 ================================= This section lists the new features introduced in components of SQL Anywhere Studio version 9.0.2. 2.1. Adaptive Server Anywhere new features --------------------------------------------- This section introduces the new features in Adaptive Server Anywhere version 9.0.2. It provides an exhaustive listing of major and minor new features, with cross references to locations where each feature is discussed in detail. SQL enhancements ---------------- UNIQUEIDENTIFIER is a 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. 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. Procedure profiling enhancements Profiling information can now be filtered per user and per connection by calling using the sa_server_option stored procedure. Remote servers can be tested before they are created or modified The Remote Server Creation 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 successfully connect before the remote server is created. The Remote Server property sheet in Sybase Central has a Test Connection button that allows you to test whether you can successfully connect to a remote server if its properties are changed. INPUT and OUTPUT statements accept ESCAPES clause This clause allows you to specify that characters are recognized and interpreted as special characters by the database server. 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. ALTER DOMAIN statement The ALTER DOMAIN statement allows you to rename user-defined domains and data types. 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. Column statistics updated during index creation The CREATE INDEX statement now has the side effect that column statistics are updated for the indexed columns. Programming interface enhancements ---------------------------------- PHP Driver The SQLAnywhere PHP module allows access to Adaptive Server Anywhere databases from the PHP scripting language. 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. 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. ODBC_DESCRIBE_BINARY_AS_VARBINARY This option allows you to choose whether you want all BINARY and VARBINARY columns to be described to your application as BINARY or VARBINARY. db_locate_servers_ex This embedded SQL 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. 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. Administrative enhancements --------------------------- SNMP Agent Adaptive Server Anywhere can now be monitored from Simple Network Management Protocol (SNMP) applications. 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. New collations The following collations have been added in this release: 1252SWEFIN has been added to support Swedish and Finnish. On Swedish and Finnish systems, the database server will choos