Following is a list of system procedure and function behavior changes added in SQL Anywhere version 16.0.
Returning information for other connections now requires privileges For version 12 or earlier databases, you do not need any permissions to execute the following system procedures and functions to return information for any connection.
For version 16 databases, any user can execute these system procedures and functions to return information for the current connection. However, to execute these system procedures and functions to return information for other connections, you must have either the SERVER OPERATOR, MONITOR, or DROP CONNECTION system privilege.
Returning information for other databases now requires privileges For version 12 and earlier databases, you did not need any permissions to execute the following system procedures and functions to return information for any database.
For version 16 databases, any user can execute these system procedures and functions to return information for the current database. However, to execute these system procedures and functions to return information for other databases, you must have either the SERVER OPERATOR or MONITOR system privilege.
TRACEBACK function enhancements The TRACEBACK function returns a call stack that is annotated with the object names and line numbers, which simplifies the process of locating the actual statements that are reported in the call stack. See TRACEBACK function [Miscellaneous].
Changes to SMTP and MAPI return codes The following changes have been made to the return codes used by the xp_startmail, xp_startsmtp, xp_sendmail, xp_stopmail, and xp_stopsmtp system procedures:
Return code | Meaning in previous releases | Meaning in version 16.0 databases | Additional information |
---|---|---|---|
-1 | Unknown error | New error code | |
0 | Success | Success | |
1 | An invalid parameter was supplied | New error code | |
2 | xp_startmail or xp_startsmtp failed | Out of memory | |
3 | xp_stopmail or xp_stopsmtp failed | xp_startmail or xp_startsmtp was not called | |
4 | Bad host name | New error code | |
5 | xp_sendmail failed | Connect error | |
6 | Secure connection error | New error code | |
7 | MAPI functions are not available | New error code |
The xp_get_mail_error_code and xp_get_mail_error_text system procedures return additional information about the return codes. You must upgrade existing databases to get the new system procedures and error codes. See:
If your application cannot be changed to check for the updated return codes, you can configure the database server to use the return codes from previous releases of the software by using the version 12 dbext.dll file and the use_old_dbextf.sql script, located in the scripts subdirectory of your SQL Anywhere installation. See Database server deployment.
USER_NAME and SUSER_NAME functions now return VARCHAR The user_name and suser_name functions now return data of type VARCHAR instead of LONG VARCHAR. If you have materialized views that use these functions, you need to rebuild them.
Error handling To allow the LOAD TABLE operation when the statement encounters errors while inserting or parsing rows, problem rows can be written to a ROW LOG and an error message written to a MESSAGE LOG. After the specifiable number of errors is encountered, the statement fails and rolls back. The following clauses have been added to support this feature:
See LOAD TABLE statement.
![]() |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |