#Sql anywhere 16 download full driver#
#Sql anywhere 16 download full upgrade#

Previously, calling the ODBC SQLGetInfo function to retrieve the version of the ODBC driver (SQL_DRIVER_VER) returned a string The ODBC driver support for escape sequences has been enhanced to include the TIMESTAMPADD and TIMESTAMPDIFF functions. The SQL Anywhere JDBC driver support for escape sequences has been enhanced to include the TIMESTAMPADD and TIMESTAMPDIFF This function can be used to register callback functions. Sacapi_bool sqlany_register_callback( a_sqlany_connection * sqlany_conn, a_sqlany_callback_type index, SQLANY_CALLBACK_PARM callback ) Support for callbacks has been added to version 3 of the SQL Anywhere C API. Support for callbacks in the SQL Anywhere C API The following database properties have been added in this release: The substringof(s1, s2) filter returns whether the s1 string is a substring of s2. OData enhancement: substringof return value This feature has been updated for build 1823. OData enhancement: Support for proxy table insertionsДЄll key properties must be explicitly specified when creating entities in entity sets that are proxy tables in a SQL

When using OData filters-such as startswith, substringof, and indexofwith-on long search strings, searches are performed OData enhancement: Search strings are restricted to 254 bytes

The concurrencytoken clause of the ENTITY OSDL statement is used to generate ETags that identify the state of an entity instance at the time the OData Producers now support Optimistic Concurrency Control as defined by version 2.0 of the OData Specification. Optimistic Concurrency Control (ETags) This feature has been updated for build 1823. Use the new embedded HTTP server option, Producers, in your OData Server configuration to create OData Producers. The OData Server now supports multiple customizable OData Producers that allow you to establish multiple database connections. Multiple OData Producer support This feature has been updated for build 1823. Sp_list_directory system procedure now also returns the date the file was created, last modified, and last accessed, as wellДЄs the owner and any access permissions required for the file or directory. In addition to returning the path, file type, and file name of all files and directories in a specified location, the Sp_list_directory system procedure enhancements The restrictions and limitations for the -gt, -gta, and -gtc database server options are preserved. Server to make use of newly added processors during runtime (also know as hot-add and hot-remove). Specified using the -gta database server option or the ProcessorAffinity server property. The sa_cpu_topology system procedure has been modified to include information about user-selected physical processors

#Sql anywhere 16 download full upgrade#

Sa_cpu_topology system procedure improvement-database upgrade or rebuild required Previously, it returned a LONG BINARY value. The procedure returns a LONG NVARCHAR value. The xp_getenv system procedure has been changed so that it is a procedure that runs with invoker privileges regardless Xp_getenv system procedure improvement-database upgrade or rebuild required