Contents Index New features in SQL Remote Upgrading Software and Databases

What's New in SQL Anywhere Studio
  What's New in Version 6.0.1

Behavior changes


This section describes behavior changes between version 6.0.0 and 6.0.1.

Java system table changes    The system tables used to record Java class information (SYSJAR, SYSJARCOMPONENT, and SYSJAVACLASS ) had SMALLINT primary keys. These data types have been altered to use INTEGER primary keys. This change allows more Java classes to be stored in a database, and more changes to the Java classes in the database.

This change takes effect for new databases and databases upgraded using the Upgrade [dbupgrad] utility from this or future releases.

Parentheses in -x command line    In previous releases, database server command lines using the -x option have used the brace character ({) to surround options. The same applies to the string in the CommLinks connection parameter. For example:

dbsrv9 -x tcpip{Localhost=demo}

Existing command lines that use braces are still supported, but it is now recommended that you use parentheses to surround the options. Use of parentheses provides support for multi-byte character set identifiers in the database server command line and the CommLinks connection parameter.

dbsrv9 -x tcpip(Localhost=demo)

ANSINULL default for Transact-SQL and jConnect connections    This has been changed to ON, which matches Adaptive Server Enterprise default behavior.

Database server -v option    Prior to Version 6, this option produced verbose output to the transaction logs. This is obsolete, and -v is now used to supply version information.

Database server -gss option    The behavior of the -gs server option, used to set the stack size, was complicated. The -gs option is now deprecated, and -gss provides the same functionality in a clearer way.

For more information, see The database server.

Character set conversion in Interactive SQL    Formerly, when the CHAR_OEM_TRANSLATION option was set to DETECT, Interactive SQL would fetch the collation label from the database to determine whether or not OEM to ANSI character set translation would be turned on. If the collation label started with a string that indicated an ANSI code page, translation would be turned off. Otherwise it would be turned on. When the option was set to DETECT, Interactive SQL would display a message in the status window indicating the collation label of the database and the display translation setting.

The new behavior is as follows. If the option is set to DETECT, Interactive SQL will obtain the CharacterSet connection property from the server. This is the character set that the server is using for sending all character strings on this connection. If this character set indicates an ANSI code page, then OEM to ANSI translation is turned off. Otherwise it is turned on. A new message is displayed, indicating the collation label of the database, the character set used for communication over this connection, and the display translation setting.


Contents Index New features in SQL Remote Upgrading Software and Databases