New login mode value for databases in the cloud   A new value, CloudAdmin, has been added for the login_mode database option. This login mode is for internal use by the cloud. See login_mode option.

Connect window enhancement in Sybase Central and Interactive SQL   The Connect window in Sybase Central and Interactive SQL now provides a Connect to a running database in a cloud option for connecting to a tenant database in the cloud.

ODBC Configuration for SQL Anywhere window enhancement   The ODBC Configuration for SQL Anywhere window in the ODBC Data Source Administrator now provides a Connect to a running database in a cloud option for connecting to a tenant database in the cloud.

NodeType (NODE) connection parameter enhancement   The NodeType connection value now supports MIRROR and READONLY values:

See NodeType (NODE) connection parameter.

New NodeType (NODE) connection parameter behavior change   When connecting to a database in the cloud, the default value for the NodeType connection parameter is PRIMARY and automatically redirects you to the tenant's primary database. When NodeType is set to DIRECT, no redirection is used and the connection succeeds only if the database is running on the host specified.

See NodeType (NODE) connection parameter.

DatabaseName connection parameter required when connecting to cloud databases   When connecting to a database in the cloud, you must specify the DatabaseName connection parameter. There is no default database name for databases in the cloud. See DatabaseName (DBN) connection parameter.

ServerName connection parameter restriction in the cloud   When connecting to a database in the cloud, you can only use the ServerName connection parameter when the NodeType connection parameter is set to DIRECT. In most cases, you should not specify ServerName or NodeType or DIRECT when connecting to a cloud server. See ServerName (Server) connection parameter.

Enhancements to SQL statements   Enhancements have been made to the following statements to facilitate their use with tenant databases in the cloud:

• ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
• ALTER SYNCHRONIZATION USER statement [MobiLink]
• START SYNCHRONIZATION SCHEMA CHANGE statement [MobiLink]

When a database is running in the cloud, some SQL Anywhere statements are not applicable or have restrictions. This information is recorded in the description of the individual functions and system procedures.

Limitations on the results from system procedures and functions when run on a database in the cloud   When a database is running in the cloud, some of the SQL Anywhere functions and system procedures only return information about the current tenant database. They do not show information about other tenant databases running on the same cloud server. This information is recorded in the description of the individual functions and system procedures.

Some database options, server options, and connection parameters not available for use in the cloud   Some database options, server, options, and connection parameters are not available for use in the cloud. More information can be found in the description for each option or parameter.

Specifying IPv6 addresses   For IPv6 addresses that include a port number, you must enclose the address in either square brackets or parentheses. See IPv6 support in SQL Anywhere.

Enhancements to loading tables   In previous releases, you could not perform load table operations on temporary tables in a read-only database. This restriction has been removed.

Previously, the LOAD TABLE default for a database running on a primary, a mirror, or a root node server was WITH FILE NAME LOGGING. Now the LOAD TABLE logging default for these types of databases is WITH ROW LOGGING.

Support added for comparing database schemas and making them the same   You can use Sybase Central to compare two databases. The comparison generates SQL statements that you can review to determine the differences between two databases. You can execute the SQL statements to make the one database the same as the other database. See Comparing database schemas and Converting a database schema to match another.

Account lockout for DBA users   To ensure that DBA users are not locked out of the database indefinitely if they enter an incorrect password, their accounts are locked for one minute once they exceed the specified number of failed connection attempts defined in their login policy. See DBA authentication.

New directory option for OEM.ini file   The directory option of the [preferences] section in the OEM.ini file specifies the directory used by the administration tools to save user-specific configuration files. These files contain information related to the administration tools' settings and history. You must specify a fully-qualified directory name that does not end in a delimiter. See Administration tools configuration.

New limits for the Timeout, SendBufferSize, and ReceiveBufferSize TCP protocol options   When using TCP/IP, the following protocol options now have upper limits.

If you specify values above these limits, a connection error is returned. See Connection error: %1.

Database mirroring enhancements   The -xa server option now supports the following values:

See -xa dbsrv12 server option.

In a high availability, read-only scale-out system, a copy node can act as the arbiter server. You must upgrade all servers in your database mirroring system to use this feature. See Using a copy node as an arbiter.

Statement performance improvements   The performance of statements that use stored procedures or user-defined functions has been improved.

LogFormat (LF) protocol option indicates unknown HTTP method for URL   If a web request fails due to an unsupported HTTP request method or a URI that is either malformed or missing a required database name, the HTTP method (@M) and HTTP version (@V) return the string ??? and the URI (@U) returns the given request preceded by >>>. See LogFormat (LF) protocol option.

New properties   The following connection properties have been added:

• LastCommitRedoPos

The following database properties have been added:

• LastCommitRedoPos
• LastWrittenRedoPos
• LastSyncedRedoPos

The following database server properties have been added:

• ProcessID

Improved performance of statements that use stored procedures or user-defined functions   Improvements have been made to the way the database server processes user-defined procedures and functions to improve performance. This performance improvement depends on the number of procedure and user-defined function calls .

ALTER SERVER statement behavior change   In previous releases, all clauses of the ALTER SERVER statement cause an automatic commit. The CONNECTION CLOSE clause no longer causes an automatic commit. See ALTER SERVER statement.

OPENSTRING clause enhancement   The OPENSTRING clause of the FROM clause now supports the [ NOT | AUTO ] COMPRESSED option and the ENCRYPTED option. The ENCRYPTED option can be used to read files that were created by the UNLOAD statement when the ENCRYPTED clause was specified. See FROM clause.

Enhancements to Certificate Creation utility (createcert)   A number of options have been added to the Certificate Creation utility to make it easier to create certificates. See Certificate Creation utility (createcert)

Enhancements to query plan strings   Plans now include known values for expressions and long plans also include information about the cached plan for a statement.

When you use application profiling, long plans now include additional information about how a query was optimize and information about the predicates used in a partial index scan.

Query optimization   An optimization has been added to infer sargable IN predicates, which can be used for partial index scans from OR predicates that cannot be transformed into AND predicates. See Optimizations performed during query processing.

Support added for ADO.NET Entity Framework 4.2   SQL Anywhere now provides support for the ADO.NET Entity Framework 4.2 Code First feature. See Entity Framework support.

New salocation option for SetupVSPackage .NET assemblies installer   The SetupVSPackage application now allows you to specify the location of the SQL Anywhere installation by using the salocation option. See .NET client deployment.

Support added to JDBC 4.0 driver for OSGi bundling   The SQL Anywhere JDBC 4.0 driver (sajdbc4.jar) now contains the proper manifest information to allow it to be loaded as an OSGi (Open Services Gateway initiative) bundle. See JDBC support.

ALTER TABLE ADD CONSTRAINT requires that not nullable columns be specified when adding a unique constraint   Improvements to the ALTER TABLE statement require that all constraint columns must be not nullable when adding a new unique constraint.

See ALTER TABLE statement [UltraLite].

MobiLink file transfers are now supported by Android smartphones   The DatabaseManager.createFileTransfer method can now be used to transfer files between an Android client and a MobiLink server.

See:

• DatabaseManager.createFileTransfer method [UltraLiteJ]
• FileTransfer interface [UltraLiteJ]
• FileTransferProgressListener interface [UltraLiteJ]
• FileTransferProgressData interface [UltraLiteJ]

ZLIB compression is now supported by Android smartphones   The UltraLiteJ API now supports ZLIB data compression for Android smartphones when synchronizing with a MobiLink server through an HTTPS protocol.

The following methods are available for Android smartphones to allow ZLIB compression:

See:

• MobiLink client network protocol options
• StreamHTTPParms interface [UltraLiteJ]

End-to-end encryption (E2EE) is now supported by Android smartphones   The UltraLiteJ API now supports end-to-end encryption for Android smartphones when synchronizing with a MobiLink server through an HTTPS protocol.

The following methods are available for Android smartphones to support E2EE:

See:

• MobiLink client network protocol options
• StreamHTTPParms interface [UltraLiteJ]

Trusted certificates from the default trusted certificate store for synchronization over the HTTPS protocol are now supported by Android smartphones   Certificates are used according to the following rules of precedence:

See:

• StreamHTTPSParms.setTrustedCertificates method [UltraLiteJ]

Cursor movement methods are now supported by Android smartphones   The UltraLiteJ API now supports all the SQL result set navigational methods that are available in other UltraLite APIs.

The following navigational methods are now available for Android smartphones:

See:

• SQL result set navigation
• ResultSet interface [UltraLiteJ]

Some BlackBerry-specific ResultSet methods are now also supported by Android smartphones   The get methods requiring a string parameter that are supported on BlackBerry smartphones are now available for Android smartphones.

The following methods are now supported by Android:

See ResultSet interface [UltraLiteJ].

ResultSetMetaData methods are now supported by Android smartphones   The following methods are now supported on Android smartphones and return values that closely approximate those returned for Blackberry smartphones.

See ResultSetMetadata interface [UltraLiteJ].

The DatabaseInfo.getPageSize method is now supported by Android smartphones   The DatabaseInfo.getPageSize method now queries the UltraLite database to retrieve the page size.

See DatabaseInfo.getPageSize method [UltraLiteJ].

The DatabaseInfo.getNumberRowsToUpload method is now supported by Android smartphones   The DatabaseInfo.getNumberRowsToUpload method now returns the number of rows awaiting upload.

See DatabaseInfo.getNumberRowsToUpload method [UltraLiteJ].

DatabaseInfo.getRelease values returned on Android smartphones now include the build number   The DatabaseInfo.getRelease method returns the full software release number.

See DatabaseInfo.getRelease method [UltraLiteJ].

Extra MobiLink client network protocol option settings are now supported by Android smartphones   The StreamHTTPParms.getExtraParameters and StreamHTTPParms.setExtraParameters methods have been added to specify and retrieve a semicolon-delimited list of MobiLink client network protocol options, and support extra options that were not previously supported by Android smartphones.

See:

• StreamHTTPParms.getExtraParameters method [Android] [UltraLiteJ]
• StreamHTTPParms.setExtraParameters method [Android] [UltraLiteJ]

Error reporting has improved for the DatabaseManager class UltraLiteJ API   A ULjException error is now thrown with the SQLE_NOT_CONNECTED error code if the connect or createDatabase methods are called after calling the release method.

See DatabaseManager.release method [UltraLiteJ].

Restartable HTTP is available for the UltraLiteJ API   When restartable HTTP is enabled, UltraLiteJ can tolerate network interruptions so that synchronizations do not fail as often on unreliable networks.

See:

• StreamHTTPParms.setRestartable method [UltraLiteJ]
• StreamHTTPParms.isRestartable method [UltraLiteJ]

Null ResultSet handling has improved for the UltraLiteJ API   Null values retrieved by the ResultSet.getString method are now returned as null, rather than an empty string.

See ResultSet.getString method [UltraLiteJ].

Row limiting on a BlackBerry smartphone always enables lazy load indexes   Databases on BlackBerry smartphones that are accessed with row limiting enabled now always lazy load indexes.

See:

• ConfigPersistent.setRowScoreFlushSize method [UltraLiteJ]
• ConfigPersistent.setRowScoreMaximum method [UltraLiteJ]

Secure synchronization of a BlackBerry smartphone through a BlackBerry Enterprise Server has improved   Some BlackBerry smartphones that synchronize over the HTTPS protocol with a BlackBerry Enterprise Server (BES) may require the ";EndToEndRequired" term to be added to the URL suffix to avoid a synchronization failure.

See StreamHTTPParms.setURLSuffix method [UltraLiteJ].

Database page sizes can be adjusted with the UltraLite Java Edition Database Load Utility with the -z option   The new -z option can be used to specify the page size, in bytes, of an UltraLite Java edition database.

See UltraLite Java Edition Database Load utility (ULjLoad).

Connection.getNewUUID and UUID.toString method support on UltraLite for M-Business Anywhere   The Connection.getNewUUID and UUID.toString methods have been reinstated.

See:

• Connection.getNewUUID method [UltraLite for M-Business Anywhere]
• UUID.toString method [UltraLite for M-Business Anywhere]

The qualified name for a table column can be obtained with the UltraLite C++ API   When used in conjunction with the ULResultSetSchema.GetColumnName method, the ul_name_type_qualified identifier of the ul_column_name_type enumeration can obtain the associated qualified name for a column in the ResultSet object.

See:

• ul_column_name_type enumeration [UltraLite C++]
• ULResultSetSchema.GetColumnName method [UltraLite C++]

The Pocket PC 2003 platform is now supported by the UltraLite C++ API   UltraLite is now supported on the Pocket PC 2003 platform. Support for TLS and HTTPS synchronization encryption is not available.

Xcode 4.2 support added to CustDB and Names samples   The CustDB and Names samples are now supported by Xcode 3.2 and 4.2.

NetworkData class added to MobiLink server APIs   A new NetworkData class has been added to the Java and .NET scripting APIs to give access to HTTP headers and client-side certificates used in a request.

See:

• NetworkData interface [MobiLink server Java]
• NetworkData interface [MobiLink server .NET]

collect_network_data protocol has been added to the mlsrv12 -x option   Use the collect_network_data protocol option with the mlsrv12 -x option to enable synchronization scripts to read network information from each synchronization. See -x mlsrv12 option.

Updates to non-synchronized columns   Updates to non-synchronized columns (except the timestamp column or logical delete column defined in the synchronization model) no longer update the timestamp column when a trigger is used in the synchronization model to maintain the timestamp.

Table mapping direction menus   The table mapping direction menus remain enabled after changing the mapping direction to "Not synchronized". See Modifying table and column mappings.

-qi option for mlsis and dbmlsync   The -qi option is now included in the usage information for mlsis and dbmlsync. See -qi dblsn option and -qi dbmlsync option.

New error messages for mlreplay   The following error messages have been added for the MobiLink replay utility:

Enhanced dbmlsync logging   Dbmlsync now prints information about the operating system and machine architecture on which it is running to the log. It also prints the platform for which the executable was compiled. See SQL Anywhere client logs.

Support for SHA2 certificates   MobiLink server and MobiLink clients now support certificates signed using SHA2. See trusted_certificate and -x mlsrv12 option.

Relay Server quick deployment on Windows IIS6, IIS7, and Apache   Relay Server provides a set of utilities that walk you through the deployment process for Windows IIS 6.0, Windows IIS 7.0 or 7.5, and Apache For more information, see:

• Deploying the Relay Server components to Microsoft IIS 6.0 on Windows Server 2003
• Deploying the Relay Server components to Microsoft IIS 7.0 or 7.5 on Windows Server 2008/Windows Server 2008 R2
• Deploying the Relay Server components to Apache on Linux

Relay Server supports identity forwarding   The SAP Gateway provides several means of authenticating clients, including X.509 certificate forwarding through trusted intermediaries. Relay Server can forward identity information from the remote client and forward it to the SAP NetWeaver Gateway or Web Dispatcher using HTTP headers. See Backend farm section properties.