Application development

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 Adaptive Server 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.

For more information, see Retrieving data, and Sending and retrieving long values.
New embedded SQL function to obtain database properties The function db_get_property can be used to obtain database properties.

For more information, see db_get_property function. For information on database properties, see 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].