Contents Index The components in your system When to upgrade your database

What's New in SQL Anywhere Studio
  Upgrading Version 5 Applications
    Understanding version 5 upgrades

Major upgrading issues


The major issues in upgrading from version 5 arise from the change in client/server communication protocol. This change means that the Version 5 interface library is not able to communicate with more recent database servers.

To help with this issue, Adaptive Server Anywhere includes a compatibility library. This DLL allows communications to both Version 5 and current database servers.

Behavior changes 

You should also check the behavior change lists elsewhere in this book for versions since version 5 for any changes that may affect your application.

In addition, applications using Transact-SQL outer joins should note the following incompatibility with newer releases:

The null-supplying table in a Transact-SQL outer join cannot also participate in another regular or outer join. For example, in the following query, table S violates this limitation as it is the null-supplying table in R.x *= S.x, and participates in another join.

-- invalid query
SELECT *
FROM R, S, T
WHERE R.x *= S.x
AND S.y = T.y

Contents Index The components in your system When to upgrade your database