New Features and Upgrading Guide
CHAPTER 3. New Features in Adaptive Server Anywhere 6.0
Many of the new features in Adaptive Server Anywhere Version 6 make it simpler to use the database system. These features are discussed individually in previous sections, but some of the major ones are collected here.
No more client executable The removal of the separate database client executable makes network communications simpler to set up. Client/server use of Adaptive Server Anywhere is now much more similar to single-machine use than in previous releases.
No more Open Server Gateway For those developing Open Client applications, there is no longer a need to use a separate Open Server Gateway executable to connect to Adaptive Server Anywhere. Instead, Adaptive Server Anywhere supports Open Client connections by itself.
Shared ODBC connection profiles Embedded SQL applications, including Sybase Central, Interactive SQL, and the command-line administration utilities, can now use ODBC data source descriptions to connect to the database. This allows ODBC data sources to be used as a common way of storing connection information.
Common connection dialog ODBC applications, Interactive SQL, and Sybase Central now all display a common connection dialog when connecting to Adaptive Server Anywhere, providing a single point of entry for users of ODBC and Embedded SQL applications.
Query rewriting Enhanced query rewrite optimization means that in many cases the particular way you construct your query is not important: the database system itself rewrites the query so it can be executed in an efficient manner. In database systems without query rewrite optimizations, it is up to the application developer to code each query in the most efficient manner.