What's New in SQL Anywhere Studio
Upgrading Version 5 Applications
Understanding version 5 upgrades
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.
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