What's New in SQL Anywhere Studio
  What's New in Version 7.0.2
    New features in version 7.0.2

Adaptive Server Anywhere new features

This section introduces the new features in Adaptive Server Anywhere version 7.0.2. It provides an exhaustive listing of major and minor new features, with cross references to locations where each feature is discussed in detail.

• Dynamic cache sizing    On Windows 95/98, the size of the database server cache increases and decreases depending on the load on the database server and the other demands on system memory. This feature removes the need for choosing an explicit cache size in many circumstances, and can also boost performance.

  For more information, see Dynamic cache sizing (Windows NT/2000/XP, Windows 95/98/Me).

• Viewing current license information    The License [dblic] utility now accepts an argument that allows you to view current license information for a server executable without starting the server.

  For more information, see The License utility.

• Additional collations    There are three new collations available: one to support Russian and Ukrainian (1251CYR, ANSI Code Page 1251), one to support Turkish (1254TRK, ANSI Code Page 1254) and one to support specialty requirements for some German users (1252DEU, ANSI Code Page 1252).

  The 1252LATIN1 collation continues to be the recommended German collation. 1252DEU is a specialty collation only, and should not be used without understanding its sorting and comparison properties.

  For a complete list of available collations, see Choosing collations.

• Interactive SQL return codes    When run from the command prompt, Interactive SQL now sets a program exit code indicating the success or otherwise of the operations in the session.

  For more information, see The Interactive SQL utility.

• DELETE_OLD_LOGS enhancement    The DELETE_OLD_LOGS database option is used in management of offline transaction logs in a replication environment. The option has been enhanced to permit more control over when processed transaction logs are deleted.

  For more information, see DELETE_OLD_LOGS option [replication].

• Connection troubleshooting and enhancements    The following changes have been made to permit better troubleshooting and tuning of client/server communications:

  • The APPINFO string is now added to the client debug log file.

    For more information, see AppInfo connection parameter [APP].

  • Two new connection parameters can be used to tune prefetching of rows.

    For more information, see PrefetchRows connection parameter [PROWS] and PrefetchBuffer connection parameter [PBUF].

  • The ConnectionName connection parameter value was previously overridden for ODBC clients. You can now use the ConnectionName parameter from ODBC clients.

    For a list of connection parameters, see Connection parameters.

• Language utility    The Language [dblang] utility allows you to report and modify the language registry for the Adaptive Server Anywhere messages and Sybase Central interface elements.

  For more information, see The Language utility.

• dbspawn enhancement    The Spawn [dbspawn] utility optionally reports the operating system process ID of the database server.

  For more information, see The Spawn utility.

• First day of week option     The default first day of week is now 7, which is Sunday. This value affects the result of DATEPART when obtaining a weekday value. You can change the first day of week using the DATEFIRST option in the Transact-SQL SET statement. You can set it permanently using SET OPTION FIRST_DAY_OF_WEEK=n.

  For more information, see SET statement [T-SQL], or FIRST_DAY_OF_WEEK option [database].

• New migration tool    You can migrate (import) remote Oracle, DB2, Microsoft SQL Server, Sybase Adaptive Server Enterprise, Sybase Adaptive Server Anywhere and Microsoft Access databases into Adaptive Server Anywhere using the new sa_migrate set of stored procedures.

  For more information, see Migrating databases to Adaptive Server Anywhere.

• Event handlers    Adaptive Server Anywhere can now determine how many instances of a particular event handler is executing at any given time. This is useful for limiting event handlers to only one instance at a time.

  For more information, see EVENT_PARAMETER function [System].

• New connection property    A new connection property helps distinguish between internal connections used to run event handlers.

  For more information, see CONNECTION_PROPERTY function [System].

• Dbdsn supports user and system specifiers    The Data Source [dbdsn] utility now supports the u (user) and s (system) options.

  For more information, see The Data Source utility.

• Support for comments in @filename files    Adaptive Server Anywhere now supports comment lines in @filename files.

  For more information, see @filename server option.

• Truncate timestamp option    To allow for greater compatibility with non-Adaptive Server Anywhere databases, you can now truncate timestamp values.

  For more information, see TRUNCATE_TIMESTAMP_VALUES option [database].

• Obtaining licensing information    Engine properties have been added to help you obtain accurate licensing information about your copy of Adaptive Server Anywhere.

  For more information, see Server-level properties.

• Resetting the autoincrement value    The sa_reset_identity system procedure allows you to reset an autoincrement value for the next row.

  For more information, see sa_reset_identity system procedure.