Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere 11 - Changes and Upgrading » What's new in version 8.0.0 » New features in version 8 » Adaptive Server Anywhere new features

 

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

    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 Understanding 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].