System procedures and functions

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

  • sa_get_table_definition system procedure   The new sa_get_table_definition system procedure returns a LONG VARCHAR string containing the SQL statements required to create the specified table and its indexes, foreign keys, triggers and granted permissions. See sa_get_table_definition system procedure.

  • FIRST_VALUE function [Aggregate]   The FIRST_VALUE function [Aggregate] now includes a RESPECT NULLS clause. See FIRST_VALUE function [Aggregate].

  • LAST_VALUE function [Aggregate]   The LAST_VALUE function [Aggregate] now includes a RESPECT NULLS clause. See LAST_VALUE function [Aggregate].

  • sa_set_http_option system procedure   The AcceptCharset option now allows more control over character set selection. See sa_set_http_option system procedure.