What's New in SQL Anywhere Studio
What's New in Version 6.0.3
New features in version 6.0.3
In addition to bug fixes, SQL Remote version 6.0.3 includes the following new features. Some features in Adaptive Server Anywhere that are particularly relevant to SQL Remote are also included in this list:
FTP and SMTP/POP support on UNIX The range of message systems supported on UNIX operating systems has been expanded to include FTP and SMTP/POP.
For a listing of supported operating and message systems, see Supported Platforms and Message Links.
Message link options stored in the database The message link parameters that control SQL Remote behavior over each message system can now be stored in the database as opposed to the registry. This simplifies deployment and management issues related to message link parameters.
For more information, see Setting message type control parameters, SET REMOTE OPTION statement, and sp_link_option procedure.
Date and time replication formats You can now specify database options that instruct SQL Remote what format to use when replicating dates and times. These options are SR_time_format, SR_date_format, and SR_timestamp_format.
For more information, see Replication of dates and times, and SQL Remote options.
Message Agent and SQL Remote Open Server run as a daemon On UNIX operating systems you can run these applications as a daemon using the -ud option.
For more information, see The Message Agent, and The SQL Remote Open Server.
Easier unload and reload of Adaptive Server Anywhere databases The Unload [dbunload] utility has been enhanced (-ar option) to allow a single-step unload and reload of a database that can be used whether or not your database is involved in replication.
For more information, see Unload utility options, and Rebuilding databases.
Enhanced transaction log [dblog] output The Transaction Log [dblog] utility now displays additional summary information, including offset information.
For more information, see Managing log files using the dblog command-line utility.
Log Translation [dbtran] utility enhancements The Log Translation [dbtran] utility permits filtering of the transaction log operations to isolate subsets of operations. This is of particular use to SQL Remote administrators.
For more information, see Translating a transaction log using the dbtran command-line utility.