Support for synchronization profiles UltraLite 11.0.0 and 11.0.1 support synchronization profiles. See ALTER SYNCHRONIZATION PROFILE statement [UltraLite], CREATE SYNCHRONIZATION PROFILE statement [UltraLite], andDROP SYNCHRONIZATION PROFILE statement [UltraLite].
UltraLite SELECT statement The default for UltraLite SELECT statements that do not explicitly contain a FOR clause is now FOR READ ONLY. This change allows UltraLite to choose more optimal plans for queries when updates are not permitted. See SELECT statement [UltraLite].
UltraLite SYNCHRONIZE statement A new statement for synchronizing an UltraLite synchronization profile or specific synchronization options. See SYNCHRONIZE statement [UltraLite].
UltraLite CREATE SYNCHRONIZATION PROFILE statement A new statement for creating an UltraLite synchronization profile. Synchronization profiles define how an UltraLite database synchronizes with the MobiLink server. See CREATE SYNCHRONIZATION PROFILE statement [UltraLite].
UltraLite ALTER SYNCHRONIZATION PROFILE statement A new statement for altering an UltraLite synchronization profile. See ALTER SYNCHRONIZATION PROFILE statement [UltraLite].
UltraLite DROP SYNCHRONIZATION PROFILE statement A new statement for deleting an UltraLite synchronization profile. See DROP SYNCHRONIZATION PROFILE statement [UltraLite].
UltraLite utilities now include support for SQL Anywhere pass-through scripts. The changes apply to the following utilities:
UltraLite database validation You can now use the ulvalid utility or ValidateDatabase API to validate an UltraLite database. The validation tests for certain types of corruption in the database file, and you can use command line parameters to refine your results. See UltraLite Validate Database utility (ulvalid) and Validating an UltraLite database.
UltraLite.NET now supports the ValidateDatabase function. You can now validate a database or specific tables with or without a connection. See ULDatabaseManager class [UltraLite.NET] and ULConnection class [UltraLite.NET].
You can now use the Validate Database Wizard in Sybase Central to validate an UltraLite database. The Validate Database option is available on the Tools menu.
Support for events and notifications UltraLite now supports events and notifications. Notification messages are sent to registered queues or connections when events occur. User events may also be defined and triggered by applications. APIs for events and notifications are provided in each supported language. Additionally, a SQL function is provided to access the API functionality.
UltraLite.NET now supports the ReadUncommitted isolation level. The default isolation level of a connection in auto-commit mode is ReadCommitted. See UltraLite transaction processing and Change the isolation level.
UltraLite ALTER DATABASE SCHEMA FROM FILE statement You can now use the ALTER DATABASE SCHEMA FROM FILE statement to alter an UltraLite schema. The ALTER DATABASE SCHEMA FROM FILE statement replaces the 9.0.2 schema upgrade feature that was implemented with the now removed UpgradeSchemaFromFile or ApplyFile methods. Use either the ulinit or ulunload utilities to ensure that the DDL statements required are syntactically correct.
Extract Database Wizard behavior changes You can now exclude tables from the extraction process, and the Extract Database Wizard now omits publications with duplicate names from the list of available publications. See Upgrading databases created with previous versions of UltraLite.
UltraLite LOAD TABLE statement The LOAD TABLE statement can now be executed on desktop computers. See UltraLite LOAD TABLE statement. See LOAD TABLE statement [UltraLite].
Background synchronization support You can now begin a synchronization on a separate thread at any point in your application and UltraLite will upload only the rows that were committed at the time the upload began. You can now modify the database during the upload and commit your changes without affecting the upload. Any rows committed while the upload is in progress are ignored by the upload. See UltraLite concurrency.
Enhanced GUID identifier support In previous versions of UltraLite, runtime allowed the input and output of UUID (Universally Unique Identifier) or GUID (Globally Unique Identifier) identifiers as either 16-byte binaries or strings. An endian conversion made the identifiers compatible with GUID structs. In UltraLite 11, GUID structs can be explicitly input and output from the runtime and the endian conversion is not required.
ul_stream_error struct In UltraLite 11, the stream_id, stream_context, and error_string_length fields are removed. In addition, the error_string field has been changed from a user-supplied char * to a static char array.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|