New cursor types The cursors supplied by Adaptive Server Anywhere have been enhanced to provide cleaner semantics, to better match new cursor types such as keyset-driven cursors, and to take advantage of the new query optimization possibilities.
For more information, see SQL Anywhere cursors.
Improved fetching for long columns The amount of data that can be fetched in a single operation has been increased from 32 KB to a configurable value with a default of 256 KB. In ODBC the value can be set using the SQL_ATTR_MAX_LENGTH statement attribute. In embedded SQL, use the DT_LONGVARCHAR and DT_LONGBINARY types.
New embedded SQL function to obtain database properties The function db_get_property can be used to obtain database properties.
blocking_timeout option The new blocking_timeout option lets you control how long a transaction waits to obtain a lock.
For more information, see blocking_timeout option [database].
return_date_time_as_string option The return_date_time_as_string option allows you to control how date, time, and timestamp values are returned over jConnect and Open Client.
For more information, see return_date_time_as_string option [database].