SQL Anywhere® 11 Changes and Upgrading February 2009 Version 11.0.1 Copyright and trademarks Copyright © 2009 iAnywhere Solutions, Inc. Portions copyright © 2009 Sybase, Inc. All rights reserved. This documentation is provided AS IS, without warranty or liability of any kind (unless provided by a separate written agreement between you and iAnywhere). You may use, print, reproduce, and distribute this documentation (in whole or in part) subject to the following conditions: 1) you must retain this and all other proprietary notices, on all copies of the documentation or portions thereof, 2) you may not modify the documentation, 3) you may not do anything to indicate that you or anyone other than iAnywhere is the author or source of the documentation. iAnywhere®, Sybase®, and the marks listed at http://www.sybase.com/detail?id=1011207 are trademarks of Sybase, Inc. or its subsidiaries. ® indicates registration in the United States of America. All other company and product names mentioned may be trademarks of the respective companies with which they are associated. Contents About this book .......................................................................................... vii About the SQL Anywhere documentation ............................................................. viii What's new in version 11.0.1 ....................................................................... 1 SQL Anywhere new features ...................................................................................... 2 SQL Anywhere behavior changes and deprecated features ................................... 8 MobiLink new features .............................................................................................. 13 MobiLink behavior changes and deprecated features ........................................... 14 QAnywhere new features .......................................................................................... 15 UltraLite new features ............................................................................................... 16 UltraLite behavior changes and deprecated features ............................................ 17 UltraLiteJ new features ............................................................................................. 18 UltraLiteJ behavior changes and deprecated features .......................................... 19 Administration tool new features ............................................................................. 20 Administration tool behavior changes and deprecated features ......................... 22 Product-wide new features ....................................................................................... 23 Documentation enhancements ................................................................................ 24 What's new in version 11.0.0 ..................................................................... 25 SQL Anywhere ........................................................................................................... 27 MobiLink ..................................................................................................................... 66 QAnywhere ................................................................................................................. 72 SQL Remote ............................................................................................................... 74 UltraLite ...................................................................................................................... 75 Sybase Central and Interactive SQL ........................................................................ 82 Documentation enhancements ................................................................................ 90 Product-wide features ............................................................................................... 91 What's new in version 10.0.1 ..................................................................... 93 SQL Anywhere ........................................................................................................... 95 Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 iii SQL Anywhere® 11 - Changes and Upgrading MobiLink ................................................................................................................... 106 QAnywhere ............................................................................................................... 108 SQL Remote ............................................................................................................. 110 UltraLite .................................................................................................................... 111 Product-wide features ............................................................................................. 113 What's new in version 10.0.0 ................................................................... 117 SQL Anywhere ......................................................................................................... 119 MobiLink ................................................................................................................... 183 QAnywhere ............................................................................................................... 204 SQL Remote ............................................................................................................. 209 UltraLite .................................................................................................................... 211 Sybase Central and Interactive SQL ...................................................................... 224 Documentation enhancements .............................................................................. 229 Product-wide features ............................................................................................. 230 What's new in version 9.0.2 ..................................................................... 235 New features in version 9.0.2 ................................................................................. 236 Behavior changes in version 9.0.2 ......................................................................... 251 What's new in version 9.0.1 ..................................................................... 257 New features in version 9.0.1 ................................................................................. 258 Behavior changes in version 9.0.1 ......................................................................... 271 What's new in version 9.0.0 ..................................................................... 275 New features in version 9.0.0 ................................................................................. 276 Behavior changes in version 9.0 ............................................................................ 293 What's new in version 8.0.2 ..................................................................... 301 New features in version 8.0.2 ................................................................................. 302 Behavior changes in version 8.0.2 ......................................................................... 311 iv Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 SQL Anywhere® 11 - Changes and Upgrading What's new in version 8.0.1 ..................................................................... 315 New features in version 8.0.1 ................................................................................. 316 Behavior changes in version 8.0.1 ......................................................................... 321 What's new in version 8.0.0 ..................................................................... 323 New features in version 8 ....................................................................................... 324 Behavior changes in version 8 ............................................................................... 344 Upgrading to SQL Anywhere 11 .............................................................. 353 Upgrading SQL Anywhere ...................................................................................... 354 Upgrading MobiLink ................................................................................................ 369 Upgrading QAnywhere ............................................................................................ 377 Upgrading UltraLite ................................................................................................. 378 Upgrading SQL Remote .......................................................................................... 386 Index .......................................................................................................... 389 Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 v vi About this book Subject This book describes new features in SQL Anywhere 11 and in previous versions of the software. For information about new features and behavior changes in versions of SQL Anywhere prior to version 8, go to http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbwnen10/ dbwnen10.html. Audience This book is for users of previous versions who want to find out what is new and different in this version of the software. Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 vii About this book About the SQL Anywhere documentation The complete SQL Anywhere documentation is available in four formats that contain identical information. ● HTML Help The online Help contains the complete SQL Anywhere documentation, including the books and the context-sensitive help for SQL Anywhere tools. If you are using a Microsoft Windows operating system, the online Help is provided in HTML Help (CHM) format. To access the documentation, choose Start » Programs » SQL Anywhere 11 » Documentation » Online Books. The administration tools use the same online documentation for their Help features. ● Eclipse On Unix platforms, the complete online Help is provided in Eclipse format. To access the documentation, run sadoc from the bin32 or bin64 directory of your SQL Anywhere 11 installation. ● DocCommentXchange DocCommentXchange is a community for accessing and discussing SQL Anywhere documentation. Use DocCommentXchange to: ○ View documentation ○ Check for clarifications users have made to sections of documentation ○ Provide suggestions and corrections to improve documentation for all users in future releases Visit http://dcx.sybase.com. ● PDF The complete set of SQL Anywhere books is provided as a set of Portable Document Format (PDF) files. You must have a PDF reader to view information. To download Adobe Reader, visit http:// get.adobe.com/reader/. To access the PDF documentation on Microsoft Windows operating systems, choose Start » Programs » SQL Anywhere 11 » Documentation » Online Books - PDF Format. To access the PDF documentation on Unix operating systems, use a web browser to open install-dir/ documentation/en/pdf/index.html. About the books in the documentation set The SQL Anywhere documentation consists of the following books: ● SQL Anywhere 11 - Introduction This book introduces SQL Anywhere 11, a comprehensive package that provides data management and data exchange, enabling the rapid development of database- powered applications for server, desktop, mobile, and remote office environments. ● SQL Anywhere 11 - Changes and Upgrading This book describes new features in SQL Anywhere 11 and in previous versions of the software. ● SQL Anywhere Server - Database Administration This book describes how to run, manage, and configure SQL Anywhere databases. It describes database connections, the database server, database viii Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 About the SQL Anywhere documentation files, backup procedures, security, high availability, replication with the Replication Server, and administration utilities and options. ● SQL Anywhere Server - Programming This book describes how to build and deploy database applications using the C, C++, Java, PHP, Perl, Python, and .NET programming languages such as Visual Basic and Visual C#. A variety of programming interfaces such as ADO.NET and ODBC are described. ● SQL Anywhere Server - SQL Reference This book provides reference information for system procedures, and the catalog (system tables and views). It also provides an explanation of the SQL Anywhere implementation of the SQL language (search conditions, syntax, data types, and functions). ● SQL Anywhere Server - SQL Usage This book describes how to design and create databases; how to import, export, and modify data; how to retrieve data; and how to build stored procedures and triggers. ● MobiLink - Getting Started This book introduces MobiLink, a session-based relational-database synchronization system. MobiLink technology allows two-way replication and is well suited to mobile computing environments. ● MobiLink - Client Administration This book describes how to set up, configure, and synchronize MobiLink clients. MobiLink clients can be SQL Anywhere or UltraLite databases. This book also describes the Dbmlsync API, which allows you to integrate synchronization seamlessly into your C++ or .NET client applications. ● MobiLink - Server Administration This book describes how to set up and administer MobiLink applications. ● MobiLink - Server-Initiated Synchronization This book describes MobiLink server-initiated synchronization, a feature that allows the MobiLink server to initiate synchronization or perform actions on remote devices. ● QAnywhere This book describes QAnywhere, which is a messaging platform for mobile, wireless, desktop, and laptop clients. ● SQL Remote This book describes the SQL Remote data replication system for mobile computing, which enables sharing of data between a SQL Anywhere consolidated database and many SQL Anywhere remote databases using an indirect link such as email or file transfer. ● UltraLite - Database Management and Reference This book introduces the UltraLite database system for small devices. ● UltraLite - C and C++ Programming This book describes UltraLite C and C++ programming interfaces. With UltraLite, you can develop and deploy database applications to handheld, mobile, or embedded devices. ● UltraLite - M-Business Anywhere Programming This book describes UltraLite for M-Business Anywhere. With UltraLite for M-Business Anywhere you can develop and deploy web-based database applications to handheld, mobile, or embedded devices, running Palm OS, Windows Mobile, or Windows. ● UltraLite - .NET Programming This book describes UltraLite.NET. With UltraLite.NET you can develop and deploy database applications to computers, or handheld, mobile, or embedded devices. ● UltraLiteJ This book describes UltraLiteJ. With UltraLiteJ, you can develop and deploy database applications in environments that support Java. UltraLiteJ supports BlackBerry smartphones and Java SE environments. UltraLiteJ is based on the iAnywhere UltraLite database product. Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 ix About this book ● Error Messages This book provides a complete listing of SQL Anywhere error messages together with diagnostic information. Documentation conventions This section lists the conventions used in this documentation. Operating systems SQL Anywhere runs on a variety of platforms. In most cases, the software behaves the same on all platforms, but there are variations or limitations. These are commonly based on the underlying operating system (Windows, Unix), and seldom on the particular variant (AIX, Windows Mobile) or version. To simplify references to operating systems, the documentation groups the supported operating systems as follows: ● Windows The Microsoft Windows family includes Windows Vista and Windows XP, used primarily on server, desktop, and laptop computers, and Windows Mobile used on mobile devices. Unless otherwise specified, when the documentation refers to Windows, it refers to all Windows-based platforms, including Windows Mobile. ● Unix Unless otherwise specified, when the documentation refers to Unix, it refers to all Unix-based platforms, including Linux and Mac OS X. Directory and file names In most cases, references to directory and file names are similar on all supported platforms, with simple transformations between the various forms. In these cases, Windows conventions are used. Where the details are more complex, the documentation shows all relevant forms. These are the conventions used to simplify the documentation of directory and file names: ● Uppercase and lowercase directory names On Windows and Unix, directory and file names may contain uppercase and lowercase letters. When directories and files are created, the file system preserves letter case. On Windows, references to directories and files are not case sensitive. Mixed case directory and file names are common, but it is common to refer to them using all lowercase letters. The SQL Anywhere installation contains directories such as Bin32 and Documentation. On Unix, references to directories and files are case sensitive. Mixed case directory and file names are not common. Most use all lowercase letters. The SQL Anywhere installation contains directories such as bin32 and documentation. The documentation uses the Windows forms of directory names. In most cases, you can convert a mixed case directory name to lowercase for the equivalent directory name on Unix. ● Slashes separating directory and file names The documentation uses backslashes as the directory separator. For example, the PDF form of the documentation is found in install-dir\Documentation\en \PDF (Windows form). x Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1