CHAPTER 1 Overview of Adaptive Server IQ System Administration

For more information on the utility database, see Chapter 3, “Configuring

Client/Server Communications” in your Adaptive Server IQ Installation and

Configuration Guide.

Compatibility with earlier versions

Version 12 of Adaptive Server IQ differs markedly from earlier versions of IQ. It offers many important new features, including the ability to update the database concurrently with query use, Transact-SQL and Java support, additional query and view support, and better front end support. It offers syntactic compatibility with Adaptive Server Anywhere, allowing Anywhere users to build on their existing knowledge base as they begin to use IQ. It also includes a new, more efficient database format.

These last two features have special implications for users migrating from pre- version 12 Adaptive Server IQ. When you migrate to version 12, you must:

Examine any scripts, applications, and procedures for differences in syntax, and make the necessary changes.

Reload your IQ database, using the special migration procedure.

See the Adaptive Server IQ Installation and Configuration Guide and the

Adaptive Server IQ Release Bulletin for your platform for migration details.

19

Page 39
Image 39
Sybase 12.4.2 manual Compatibility with earlier versions