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

SQL Anywhere 12.0.0 » SQL Anywhere 12 - Changes and Upgrading » What's new in version 11.0.0 » SQL Anywhere » SQL Anywhere new features


Database connections

Following is a list of enhancements made to database connections in SQL Anywhere version 11.0.0.

  • AppInfo connection parameter enhancements   The AppInfo connection parameter now supports the OSUSER key. This key returns the operating system user name associated with the client process. Linux and Solaris now support the EXE key. See AppInfo (APP) connection parameter.

  • Elevate connection parameter   The Elevate connection parameter elevates automatically started SQL Anywhere database servers on Windows Vista. See Elevate connection parameter.

  • NewPassword connection parameter [NEWPWD]   The NewPassword connection parameter allows users to change passwords, even if they have expired, without DBA intervention. See NewPassword (NEWPWD) connection parameter.

  • Prefetch enhancements   The default values for the PrefetchBuffer (PBUF) connection parameter have changed. On Windows Mobile, the default value is now 64 KB, and on all other platforms the default value is now 512 KB. This connection parameter accepts values between 64 KB and 8 MB. See PrefetchBuffer (PBUF) connection parameter.

    In previous versions, the maximum number of prefetched rows was based on the maximum amount of data that could be prefetched. Now, the maximum number of prefetched rows takes into account the actual amount of prefetched data, as well as the data limit specified by the PrefetchBuffer connection parameter. This can result in significant performance gains when the amount of data in a column is significantly less than both the host variable length and describe length.

    Prefetch also dynamically increases the number of prefetch rows in situations that are likely to result in improved performance. See Prefetching rows.