ASAnywhere8 Adaptive Server Anywhere 8

SQL Anywhere 8.0.1 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 8.0.1 Known issues and limitations * Fonts on Japanese machines * sa_migrate procedure parameters Documentation corrections * Printed documentation corrections and missing items Updated Components ================== The following components are included in this version of SQL Anywhere: Adaptive Server Anywhere Version 8.0.1 jConnect for JDBC Version 4.5 and 5.5 EBF 9689 Sybase Central Version 4.1.1 New Features in SQL Anywhere 8.0.1 ================================== 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. Adaptive Server Anywhere ------------------------ You can reduce table fragmentation by specifying the percentage of free space that should be reserved in table pages. The sa_disk_free procedure allows you to determine the space available for your dbspaces, temporary file, transaction log, and transaction log mirror. Database administrators can use the sa_flush_statistics procedure to ensure that cost model statistics that exist only in the database server cache are flushed out. The REWRITE function accepts a new argument, ANSI, which causes the function to return the ANSI equivalent of any SELECT, UPDATE, or DELETE statement. The SET clause of the UPDATE statement can now be used to assign a value to a variable, in addition to updating the table. You can use square brackets to delimit identifiers. Square brackets can always be used, regardless of the setting of the QUOTED_IDENTIFIER option. You can use the WITH table-hint argument to specify a locking method for a particular table or view for a particular SELECT, UPDATE, or DELETE statement. The Data Migration wizard allows you to migrate remote tables to an Adaptive Server Anywhere database from Sybase Central. Sybase Central now allows you to connect to a version 5.x of 6.x database in order to upgrade the database file format using the Unload Database wizard. To do this, you must run the database on a version 8.0.0 or later server. You can now back up your database files, including the main database file, the transaction log, and dbspaces from the Sybase Central Upgrade Database wizard. The sa_migrate procedure has an optional argument, migrate_fkeys that allows you to specify whether or not you want to migrate foreign key mappings when you migrate tables from a remote database. The SORT_COLLATION database option allows implicit use of the SORTKEY function on ORDER BY expressions. When the value of this option is set to a valid collation name or collation ID, any string expression in the ORDER BY clause is treated as if the SORTKEY function had been invoked. You can use the VerifyServerName=NO connection parameter to allow Adaptive Server Anywhere clients to connect to an Adaptive Server Anywhere server if they know only an IP address/port. You can use the LocalOnly connection parameter to connect only to a server on the local machine, if one exists. You can use the DBFileFragments and LogFileFragments database properties to monitor file fragmentation. Two new connection properties have been added. LivenessTimeout returns the liveness timeout of the connection, and IdleTimeout returns the idle timeout of the connection. Known issues ============ Fonts on Japanese machines -------------------------- On Japanese machines, the graphical administration tools no longer use the Windows system font by default. This feature has been disabled because of a problem reported on some machines which causes the programs to hang on startup. If you wish to reenable the use of system fonts, you must create the following registry string: HKEY_LOCAL_MACHINE\ SOFTWARE\ Sybase\ Adaptive Server Anywhere\ AlwaysUseSystemFonts The value must be set to "1". sa_migrate procedure parameters ------------------------------- Do not specify NULL for both tableName and ownerName parameters. Supplying NULL for both the tableName and ownerName parameters forces an attempt to migrate all tables in the database, including system tables. Instead, it is recommended that you migrate tables associated with one owner at a time. Documentation corrections ========================= Printed documentation corrections and missing items --------------------------------------------------- The following corrections apply to the printed documentation only. The printed documentation is written for version 8.0.0, while the online books are updated to reflect 8.0.1. The online books contain the corrections. Database options The BLOCKING_TIMEOUT and RETURN_DATE_TIME_AS_STRING options are not described in the printed books. The STRING_RTRUNCATION option is incorrectly listed as the STRING_TRUNCATION in some locations in the printed books. These items can be located from the online books index. SQLSetConnectAttr prototype incorrect In the ASA Programming Guide, chapter 7, the prototype of the ODBC function SQLSetConnectAttr is listed incorrectly. The correct prototype can be found from the online books index.