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

Adaptive Server Anywhere new features

In addition to bug fixes, Adaptive Server Anywhere version 6.0.2 includes new features in both the software and the documentation.

• UltraLite deployment option    UltraLite databases for small devices such as the PalmPilot and Windows CE computers can be developed with this version of the software.

  For information, see the book UltraLite Developer's Guide.

• Backup and Restore SQL statements    Adding BACKUP and RESTORE as SQL statements provides server side backup and automation of backups using SQL scripts.

  The BACKUP statement provides direct backup to tape.

  For more information, see BACKUP statement.

• Security features    New security features have been added.

  • Auditing    Database administrators can keep track of activity performed on a database by turning on the AUDITING option. The record of activities is kept in the transaction log. By turning on auditing, you increase the amount of data saved in the transaction log to include login attempts, accurate timestamps of all events, all permissions checks, and all actions requiring DBA authority.

    For more information, see Auditing database activity.

  • Minimum password length    Database administrators can specify a minimum password length, to discourage easily discovered passwords.

    For more information, see MIN_PASSWORD_LENGTH option [database].

• Locating servers    A utility is provided for troubleshooting connections.

  For more information, see The Ping utility.

• Starting databases from jConnect connections    Database connections over TDS, including connections from Java applications over jConnect, can start a database on a server.

  For more information, see Supplying a URL for the server.

• getObject and setObject methods from Java client applications    From Java applications, you can now retrieve objects from a table and insert objects into a table without the explicit serialization and deserialization required in previous releases.

• ODBC 3.51    The ODBC driver has been updated to ODBC 3.51. This version of ODBC includes support for Unicode applications.

  For more information, see ODBC conformance.

• Control of allowed JOIN syntax    In previous releases, some multi-table queries have been allowed that have ambiguous join clauses. In the present release, you can set an option to disallow such queries.

  For more information, see EXTENDED_JOIN_SYNTAX option [database].

• Administration utility enhancements    Options have been added to the administration utilities to provide additional features.

  • Transaction Log [dbtran] utility    If you use the new -d option, dbtran puts each operation as it occurs in the transaction log file. This makes transaction log output easier to read. This has been added primarily for auditing purposes.

    For more information, see Translating a transaction log using the dbtran command-line utility.

  • Transaction Log [dbtran] utility    You can run dbtran against a running database server instead of against a log file. This feature has been added to increase the security of the transaction log—there is now no need to access the transaction log directly.

    For more information, see Translating a transaction log using the dbtran command-line utility.

  • Log Transfer Manager [dbltm] utility logging    New options allow you to tune message logging from these utilities.

    For more information, see The Log Transfer Manager.

  • New Log Transfer Manager [dbltm] utility options    New options enable you to replicate only backed up transactions (backup_only), and to shut down as soon as all data is replicated (continuous).

    For more information, see The LTM configuration file.