What's New in SQL Anywhere Studio
What's New in Version 8.0.0
New features in version 8
Adaptive Server Anywhere new features
Connections persist across hibernation times Connections from embedded SQL, ODBC or OLE DB clients now persist while a computer hibernates. Previously, TCP/IP connections between a client and a server on the same machine would be dropped when the machine was woken from hibernation if the machine hibernated for longer than the liveness or idle timeout time.
Viewing current license information The 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.
Viewing collation label and name for custom collations The dbinfo command line utility now returns the collation label and name for custom collations. As well, two new fields, collationnamebuffer and collationnamebufsize, have been added to the a_db_info structure in dbtools.h.
For more information, see Obtaining database information using the dbinfo command-line utility and a_dbtools_info structure.
sp_remote_tables system procedure A new argument, tabletype, has been added to the sp_remote_tables stored procedure. This argument returns the remote table's type.
For more information about the tabletype argument, see sp_remote_tables system procedure.
-ct command line option Using the -ct
command line option, you can turn character set translation on and off. Character set translation is now enabled by default, and to turn it off, you can specify -ct-
. To turn character set translation on, use -ct+
.
For more information, see -ct server option.
Obtain remote table foreign key information Two new stored procedures, sp_remote_exported_keys and sp_remote_imported_keys, allow you to obtain information about foreign keys and their corresponding primary keys for remote tables.
For more information, see sp_remote_exported_keys system procedure and sp_remote_imported_keys system procedure.
xp_sendmail There are now extended stored procedures for sending email over SMTP as well as MAPI. For more information, see xp_startsmtp system procedure and xp_stopsmtp system procedure.
The xp_sendmail stored procedure now accepts messages of any length. The length of the long VARCHAR parameters for the procedure is limited to the amount of memory available on your system.
For more information, see xp_sendmail system procedure.
Replication Server 12 feature for the log transfer manager The qualify_table_owner parameter in the LTM configuration file provides support for the Replication Server 12 feature allowing the table names, owners, and column names in the primary databases to be different from the replication databases.
For more information, see The LTM configuration file.
ASANYSH8 environment variable A new environment variable, ASANYSH8, has been added. Interactive SQL, Sybase Central, the Console utility, and the debugger use this environment variable to located the shared components directory.
For more information about the ASANYSH8 environment variable, see ASANYSH8 environment variable.