While many features are available when you run an older database on the latest version of the database server, to access some features you must rebuild (unload and reload) your database, perform an upgrade on the database file, or update your client libraries.
Features not listed in the categories below only require a SQL Anywhere 16.0 database server; they do not require existing databases to be upgraded or the client libraries to be updated. For a complete list of new features in SQL Anywhere 16, see What's new in version 16.0.
Differences between a rebuilt (unload/reload) database and an upgraded databaseUpgraded databases An upgraded database is a database that has had some of its features updated. For example, an upgrade updates the system tables and views, adds new database options, recreates all system stored procedures, installs jConnect support, and changes support for Java in the database. Upgrade a database by using the Upgrade utility (dbupgrad) or the Upgrade Database Wizard in Sybase Central.
Rebuilt databases A rebuilt database is a new database that contains the data from an older database. Rebuild a database by using the UNLOAD statement or the Unload utility (dbunload) with the -an option.
Features that require a rebuild (unload/reload) of your databaseUltraLite version 16 cannot connect to databases that were created with earlier versions of UltraLite. Therefore, an unload/reload is required. However, UltraLite version 11 or later clients can synchronize with MobiLink version 16.
The ADD COLUMN clause of the ALTER TABLE statement (version 10 and earlier databases). See ALTER TABLE statement.
CESU-8 character set support. For information about supported collations, see Alternate collations.
Features that require only an upgrade (dbupgrad utility or UPGRADE DATABASE statement)Features that require only an upgraded database also work if you unload/reload your database.
SMTP and MAPI new error codes and changed return codes. See Return codes for MAPI and SMTP system procedures.
ADD COLUMN clause of the ALTER TABLE statement (version 11 and later databases). See ALTER TABLE statement.
CREATE INDEX statement. See CREATE INDEX statement.
Roles and privileges, including changes made to Sybase Central to support the new role-based security model. See New security model: Role-based access control (RBAC).
Some system procedures are now run with the privileges of the invoker, rather than the definer (owner). See Set procedures and functions to run with owner or invoker privileges.
LDAP user authentication support. See LDAP user authentication.
ROW and ARRAY data type support. See Composite data types.
OData support. See OData support.
Reserved words:
Login policy options:
See Root login policy.
Database options:
Database server options:
Connection properties:
System views:
System tables:
Timestamps are now stored as their UTC (Coordinated Universal Time) based equivalent in system tables, but system views expose both UTC timestamps and local timestamps. Applications that rely on the number of columns in the following system views and/or their underlying tables must be updated:
Functions:
Operators:
System procedures:
New or enhanced SQL statements:
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |