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 [ASTART].
MESSAGE statement Extensions to the MESSAGE statement allow messages to be directed to the client, the Server Messages 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 Implementing request management.
More control over operating system threads A new database server 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 SQL Anywhere database server.
Connection property system procedures The sa_conn_properties_by_conn and sa_conn_properties_by_name system procedures provide alternative ways of querying connection information.
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.