As with all forward-looking statements, the lists of deprecated features are not guaranteed to be complete and are subject to change.
Address Windowing Extensions (AWE) deprecated The use of Address Windowing Extensions for 32-bit Windows is deprecated. If you need a large cache, it is recommended that you use the 64-bit version of the SQL Anywhere database server on a 64-bit operating system. See -cw dbeng12/dbsrv12 server option (deprecated).
CALL statement Use of this statement to invoke a function is deprecated. If you have a function you want to call, consider using an assignment statement to invoke the function and assign its result to a variable. For example:
DECLARE varname INT; SET varname=test( ); |
See CALL statement.
STOP ENGINE statement The STOP ENGINE statement is deprecated. Use the STOP SERVER statement instead. See STOP SERVER statement.
Windows 2000 support removed As of version 12.0.0, SQL Anywhere is no longer supported on Windows 2000.
Rebuild utility removed The Rebuild utility is not supported in this release for rebuilding SQL Anywhere databases. You can rebuild databases using the Unload utility (dbunload). See Unload utility (dbunload).
Unsupported database properties The following properties have been removed in this release:
JDBC-based server classes deprecated Support for the following JDBC-based server classes has been deprecated:
Applications should be updated to use the ODBC-based server classes. See Defining ODBC external servers.
SQL Anywhere Explorer no longer supported The SQL Anywhere Explorer and SQL Anywhere Toolbar for Visual Studio are no longer supported. Use Microsoft's Server Explorer instead.
Short int embedded SQL indicator variable deprecated To allow for the future use of 32- and 64-bit lengths and indicators, the use of short int for embedded SQL indicator variables is deprecated. Use a_sql_len instead. See Indicator variables.
EngineName (ENG) connection parameter deprecated The EngineName (ENG) connection parameter is deprecated. You can use the ServerName (Server) connection parameter instead. The short form of the ServerName connection parameter has been changed from ENG to Server. See ServerName (Server) connection parameter.
iAnywhere JDBC driver deprecated The Type 1 iAnywhere JDBC driver is deprecated. Use the Type 2 SQL Anywhere JDBC driver instead. See New SQL Anywhere TYPE-2 JDBC driver.
-gu all database server option deprecated The value all for the -gu database server option is deprecated. See -gu dbeng12/dbsrv12 server option.
SET OPTION statement The ability to specify an identifier as an option value in a SET OPTION statement, rather than a string literal, has been deprecated.
Service utility (dbsvc utility) The value Standalone for the -t option has been deprecated. Use -t Personal instead to create a service for the personal database server. See Service utility (dbsvc) for Linux and Service utility (dbsvc) for Windows.
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |