New Features and Upgrading Guide
CHAPTER 2. New Features in Adaptive Server Anywhere 6.0.1
Several other features have been added to Adaptive Server Anywhere 6.0.1. These include the following:
jConnect 4.0 The version of jConnect included in this product has been updated to version 4.0.
Autostart connection parameter This parameter prevents a personal server from starting if no network connection is successful.
For a description, see AutoStart connection parameter.
MESSAGE statement Extensions to the MESSAGE statement allow messages to be directed to the client, the server window, or a log file.
For a description, see MESSAGE statement.
Message callbacks Windows Embedded SQL applications can handle messages received from the server while a request is being processed by registering a message callback function.
For more information, see Windows request management functions.
More control over operating system threads A new database server command-line option (-gx) controls the number of operating system threads that are in use. The existing -gt option controls how many can be in use at one time, effectively controlling the number of CPUs that can be exploited.
For more information, see The database server.
Connection property system procedures Two additional system procedures provide alternative ways of querying connection information.
For more information, see sa_conn_properties_by_conn system procedure, and sa_conn_properties_by_name system procedure.
NULLIF function This provides an abbreviated form of the CASE expression. NULLIF compares the values of the two expressions. If the first expression equals the second expression, NULLIF returns NULL. If the first expression does not equal the second expression, NULLIF returns the first expression. The NULLIF function provides a short way to write some CASE expressions.
For more information, see Miscellaneous functions.