Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere 12 - Changes and Upgrading » What's new in version 11.0.0 » SQL Anywhere » SQL Anywhere new features


System procedures and functions

Following is a list of system procedure and function enhancements added in SQL Anywhere version 11.0.0.

  • sa_get_dtt_groupreads system procedure   The new sa_get_dtt_groupreads system procedure allows you to estimate the cost of issuing group reads on the database server. See sa_get_dtt_groupreads system procedure.

  • PROPERTY_NAME function enhancement   Now returns the name of the property with the supplied property ID for the specified connection level. See PROPERTY_NAME function [System].

  • READ_CLIENT_FILE function   The new READ_CLIENT_FILE function reads data from the specified file on the client computer. See READ_CLIENT_FILE function [String].

  • WRITE_CLIENT_FILE function   The new WRITE_CLIENT_FILE function writes data to the specified file on the client computer. See WRITE_CLIENT_FILE function [String].

  • REGEXP_SUBSTR function   The new REGEXP_SUBSTR function allows you to search for a substring within a string. This new function takes a regular expression as an argument. See REGEXP_SUBSTR function [String].

  • sa_char_terms system procedure   The new sa_char_terms system procedure breaks a CHAR string into terms and returns every term together with its position. See sa_char_terms system procedure.

  • sa_nchar_terms system procedure   The new sa_nchar_terms system procedure breaks an NCHAR string into terms and returns every term together with its position. See sa_nchar_terms system procedure.

  • sa_refresh_text_indexes system procedure   The new sa_refresh_text_indexes system procedure refreshes all text indexes that are defined as MANUAL REFRESH or AUTO REFRESH. See sa_refresh_text_indexes system procedure.

  • sa_text_index_stats system procedure   The new sa_text_index_stats system procedure returns statistical information for all text indexes in the database, including the last refresh time and size of pending changes. See sa_text_index_stats system procedure.

  • sa_text_index_vocab system procedure   The new sa_text_index_vocab system procedure lists all terms that appear in a text index, and the total number of indexed values that each term appears in. See sa_text_index_vocab system procedure.

    Two new system procedures, sa_internal_text_index_vocab and sa_internal_text_index_postings have also been added, but are only for use by the sa_text_index_vocab system procedure.

  • sa_text_index_postings system procedure   This new system procedure is for internal use only.

  • sa_text_index_handles system procedure   This new system procedure is for internal use only.

  • sa_get_user_status system procedure   The new sa_get_user_status system procedure allows you to determine a user's current login status. See sa_get_user_status system procedure.

  • Running procedures and functions as invoker   When creating a procedure or function, you can now specify whether the procedure or function runs as though it was called by the user calling it (invoker), or by the user who created it (definer). To specify this, use the SQL SECURITY clause of the CREATE PROCEDURE or CREATE FUNCTION statement. See CREATE FUNCTION statement and CREATE PROCEDURE statement.

    This change also applies to external procedures and functions.

  • sa_disk_free_space system procedure   The sa_disk_free_space system procedure now returns a new column, total_space, indicating the total amount of disk space available on the drive where the dbspace resides. For databases created on versions of SQL Anywhere before 11.0.0, the total_space column is not returned until the database is upgraded. See sa_disk_free_space system procedure.

  • sa_external_library_unload system procedure   A new system procedure, sa_external_library_unload, has been added to allow you to unload external libraries that are not in use. See sa_external_library_unload system procedure.

  • sa_index_density system procedure now returns skew   The sa_index_density system procedure has been enhanced to return the amount of skew present in the index. A high degree of skew can impact performance compared to a well balanced index. See Reduce index fragmentation and skew and sa_index_density system procedure.

  • sa_materialized_view_info system procedure enhancements   Information in the Status column returned by sa_materialized_view_info has been split into two columns, Status and DataStatus. The Status now returns information on whether the view is enabled or disabled. The new DataStatus column returns information about whether there is data in the view, and the freshness of the data. An additional column, RefreshType, has been added to indicate whether the view is a manual view or an immediate view. See sa_materialized_view_info system procedure.

  • sa_materialized_view_can_be_immediate system procedure   Newly created materialized views are manual views by default, but can be altered to become immediate views, providing they do not violate any of the restrictions for immediate views. The new sa_materialized_view_can_be_immediate system procedure allows you to test whether a manual view can be changed to an immediate view. See sa_materialized_view_can_be_immediate system procedure and Additional restrictions for immediate views.

  • sa_post_login_procedure system procedure   A new system procedure has been added to allow you to determine if a warning should be issued when a user's password is about to expire. See sa_post_login_procedure system procedure.

  • EVENT_PARAMETER function enhancement   The EVENT_PARAMETER function now supports abnormal as a DisconnectReason. This new reason indicates that a disconnect occurred either as a result of the client application shutting down abnormally before disconnecting from the database, or as a result of a communication failure between the client and server computers. See EVENT_PARAMETER function [System].

  • sa_server_option system procedure enhancements   Two new properties, OptionWatchList and OptionWatchAction, have been added to the sa_server_option system procedure. You can use these properties to monitor when an attempt is made to change a database option setting, and specify the action to take. See Monitoring option settings and sa_server_option system procedure.

  • sa_db_properties system procedure enhancement   The sa_db_properties system procedure now returns valid properties that have NULL values. See sa_db_properties system procedure.

  • sa_conn_properties system procedure enhancement   The sa_conn_properties system procedure now returns valid properties that have NULL values. See sa_conn_properties system procedure.