利用以下选项，您可以配置 SQL Anywhere 数据库的行为。
| 选项 | 值 | 缺省值 | 所需特权 |
|---|---|---|---|
| allow_nulls_by_default 选项 | On、Off |
On 对 Sybase Open Client 和 jConnect 连接为 Off |
SET ANY PUBLIC OPTION |
| allow_read_client_file 选项 | On、Off | Off | SET ANY SECURITY OPTION |
| allow_snapshot_isolation 选项 | On、Off | Off | SET ANY SYSTEM OPTION |
| allow_write_client_file 选项 | On、Off | Off | SET ANY SECURITY OPTION |
| ansi_blanks 选项 | On、Off | Off | SET ANY PUBLIC OPTION |
| ansi_close_cursors_on_rollback 选项 | On、Off | Off | SET ANY PUBLIC OPTION |
| ansi_permissions 选项 | On、Off | On | SET ANY SYSTEM OPTION |
| ansi_substring 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| ansi_update_constraints 选项 | Off、Cursors、Strict | Cursors | SET ANY PUBLIC OPTION |
| ansinull 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| auditing 选项 | On、Off | Off | SET ANY SECURITY OPTION |
| auditing_options 选项（保留供系统使用） | 保留 | 保留 | SET ANY SECURITY OPTION |
| auto_commit_on_create_local_temp_index 选项 | On、Off | Off | SET ANY SYSTEM OPTION |
| background_priority 选项 [不建议使用] | On、Off | Off | SET ANY PUBLIC OPTION |
| blocking 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| blocking_others_timeout 选项 | 整数（以毫秒为单位） | 0 | SET ANY PUBLIC OPTION |
| blocking_timeout 选项 | 整数（以毫秒为单位） | 0 | SET ANY PUBLIC OPTION |
| chained 选项 | On、Off |
On 对 Sybase Open Client 和 jConnect 连接为 Off |
SET ANY PUBLIC OPTION |
| checkpoint_time 选项 | 分钟数 | 60 | SET ANY SYSTEM OPTION |
| cis_option 选项 | 0, 7 | 0 | SET ANY PUBLIC OPTION |
| cis_rowset_size 选项 | 整数 | 50 | SET ANY PUBLIC OPTION |
| close_on_endtrans 选项 | On、Off |
On jConnect 连接为 Off |
SET ANY PUBLIC OPTION |
| collect_statistics_on_dml_updates 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| conn_auditing 选项 | On、Off | On | SET ANY SECURITY OPTION |
| connection_authentication 选项 | 字符串 | 空字符串 | SET ANY PUBLIC OPTION |
| continue_after_raiserror 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| conversion_error 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| cooperative_commit_timeout 选项 | 整数（以毫秒为单位） | 250 | SET ANY PUBLIC OPTION |
| cooperative_commits 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| database_authentication 选项 | 字符串 | 空字符串 | SET ANY SECURITY OPTION |
| date_format 选项 | 字符串 | YYYY-MM-DD | SET ANY PUBLIC OPTION |
| date_order 选项 | MDY、YMD、DMY | YMD | SET ANY PUBLIC OPTION |
| db_publisher 选项 | 用户 ID | -1 | SET ANY SYSTEM OPTION |
| debug_messages 选项 | On、Off | Off | SET ANY PUBLIC OPTION |
| dedicated_task 选项 | On、Off | Off | SET ANY SYSTEM OPTION |
| default_dbspace 选项 | 字符串 | 空字符串（使用系统 dbspace） | SET ANY PUBLIC OPTION |
| default_timestamp_increment 选项 | 整数（代表微秒，1 到 1000000） | 1 | SET ANY PUBLIC OPTION |
| delayed_commit_timeout 选项 | 整数（以毫秒为单位） | 500 | SET ANY PUBLIC OPTION |
| delayed_commits 选项 | On、Off | Off | SET ANY PUBLIC OPTION |
| disk_sandbox 选项 | On、Off | Off | SET ANY SECURITY OPTION |
| divide_by_zero_error 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| escape_character 选项 | 保留 | 保留 | SET ANY PUBLIC OPTION |
| exclude_operators 选项 | 保留 | 保留 | SET ANY SYSTEM OPTION |
| extended_join_syntax 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| extern_login_credentials 选项 | Login_user、Effective_user | Login_user | SET ANY SECURITY OPTION |
| fire_triggers 选项 | On、Off | On | SET ANY SYSTEM OPTION |
| first_day_of_week 选项 | 1, 2, 3, 4, 5, 6, 7 | 7（星期日是一周中的第一天） | SET ANY PUBLIC OPTION |
| for_xml_null_treatment 选项 | Empty、Omit | Omit | SET ANY PUBLIC OPTION |
| force_view_creation 选项 | 保留 | 保留 | SET ANY SYSTEM OPTION |
| global_database_id 选项 | 整数 | 2147483647 | SET ANY SYSTEM OPTION |
| http_connection_pool_basesize 选项 | 整数（0 到 1000） | 10 | SET ANY SYSTEM OPTION |
| http_connection_pool_timeout 选项 | 整数（1 到 86400，以秒为单位） | 60 | SET ANY SYSTEM OPTION |
| http_session_timeout 选项 | 整数 | 30 | SET ANY PUBLIC OPTION |
| integrated_server_name 选项 | 字符串 | NULL | SET ANY SECURITY OPTION |
| isolation_level 选项 | 0、1、2、3、快照、语句快照、只读语句快照 | 0 | SET ANY PUBLIC OPTION |
| java_class_path 选项 | 字符串 | 空字符串 | SET ANY SYSTEM OPTION |
| java_location 选项 | 字符串 | 空字符串 | SET ANY SYSTEM OPTION |
| java_main_userid 选项（不建议使用） | 字符串 | 空字符串 | SET ANY SYSTEM OPTION |
| java_vm_options 选项 | 字符串 | 空字符串 | SET ANY SYSTEM OPTION |
| log_deadlocks 选项 | On、Off | Off | SET ANY SYSTEM OPTION |
| login_mode 选项 | Standard、Integrated、Kerberos、LDAPUA、CloudAdmin、Mixed（不建议使用） | Standard | SET ANY SECURITY OPTION |
| login_procedure 选项 | 字符串 | sp_login_environment | SET ANY SECURITY OPTION |
| materialized_view_optimization 选项 | Disabled、Fresh、Stale、N { Minute[s] | Hour[s] | Day[s] | Week[s] | Month[s] } | Stale | SET ANY PUBLIC OPTION |
| max_client_statements_cached 选项 | 整数 | 10 | SET ANY PUBLIC OPTION |
| max_cursor_count 选项 | 整数 | 50 | SET ANY SYSTEM OPTION |
| max_plans_cached 选项 | 整数 | 20 | SET ANY PUBLIC OPTION |
| max_priority 选项 | Critical、High、Above Normal、Normal、Below normal、Low、Background | Normal | SET ANY SYSTEM OPTION |
| max_query_tasks 选项 | 整数 | 0 | SET ANY PUBLIC OPTION |
| max_recursive_iterations 选项 | 整数 | 100 | SET ANY PUBLIC OPTION |
| max_statement_count 选项 | 大于等于 0 的整数 | 50 | SET ANY SYSTEM OPTION |
| max_temp_space 选项 | 整数 [k|m|g|p] | 0 | SET ANY SYSTEM OPTION |
| min_password_length 选项 | 大于等于 0 的整数 | 0 个字符 | SET ANY SECURITY OPTION |
| min_role_admins 选项 | 1 到 10（含）之间的整数 | 1 | SET ANY SECURITY OPTION |
| nearest_century 选项 | 0 到 100（含）之间的整数 | 50 | SET ANY PUBLIC OPTION |
| non_keywords 选项 | 字符串 | 空字符串 | SET ANY PUBLIC OPTION |
| odbc_describe_binary_as_varbinary | On、Off | Off | SET ANY PUBLIC OPTION |
| odbc_distinguish_char_and_varchar 选项 | On、Off | Off | SET ANY PUBLIC OPTION |
| oem_string 选项 | 字符串（最多 128 字节） | 空字符串 | SET ANY SYSTEM OPTION |
| on_charset_conversion_failure 选项 | Ignore、Warning、Error | Ignore | SET ANY PUBLIC OPTION |
| on_tsql_error 选项 | Stop、Conditional、Continue |
Conditional 对 JConnect 连接，继续执行 |
SET ANY PUBLIC OPTION |
| optimization_goal 选项 | First-row 或 All-rows | All-rows | SET ANY PUBLIC OPTION |
| optimization_level 选项 | 0-15 | 9 | SET ANY PUBLIC OPTION |
| optimization_workload 选项 | Mixed、OLAP | Mixed | SET ANY SYSTEM OPTION |
| pinned_cursor_percent_of_cache 选项 | 0-100 之间的整数 | 10 | SET ANY SYSTEM OPTION |
| post_login_procedure 选项 | 字符串 | 空字符串 | SET ANY SECURITY OPTION |
| precision 选项 | 1 到 127（含）之间的整数 | 30 | SET ANY PUBLIC OPTION |
| prefetch 选项 | Off、Conditional、Always | Conditional | SET ANY PUBLIC OPTION |
| preserve_source_format 选项 | On、Off | On | SET ANY SYSTEM OPTION |
| prevent_article_pkey_update 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| priority 选项 | Critical、High、Above Normal、Normal、Below normal、Low、Background | Normal | SET ANY PUBLIC OPTION |
| progress_messages 选项 | Off、Formatted、Raw | Off | SET ANY PUBLIC OPTION |
| query_mem_timeout 选项 | -1、0、正整数 | -1 | SET ANY PUBLIC OPTION |
| quoted_identifier 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| read_past_deleted 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| recovery_time 选项 | 整数（以分钟为单位） | 2 | SET ANY SYSTEM OPTION |
| remote_idle_timeout 选项 | 整数（以秒为单位） | 15 | SET ANY PUBLIC OPTION |
| request_timeout 选项 | 整数（0 到 86400，以秒为单位） | 0 | SET ANY PUBLIC OPTION |
| reserved_keywords 选项 | 字符串 | 空字符串 | SET ANY SYSTEM OPTION |
| return_date_time_as_string 选项 | On、Off | Off | SET ANY PUBLIC OPTION |
| rollback_on_deadlock | On、Off | On | SET ANY PUBLIC OPTION |
| row_counts 选项 | On、Off | Off | SET ANY PUBLIC OPTION |
| scale 选项 | 0 到 127（含）之间的整数，小于为 precision 数据库选项指定的值 | 6 | SET ANY PUBLIC OPTION |
| 字符串 | NULL | SET ANY PUBLIC OPTION | |
| sort_collation 选项 | Internal、collation_name 或 collation_id | Internal | SET ANY PUBLIC OPTION |
| sql_flagger_error_level 选项 | Off、SQL:1992/Entry、SQL:1992/Intermediate、SQL:1992/Full、SQL:1999/Core、SQL:1999/Package、SQL:2003/Core、SQL:2003/Package、UltraLite | Off | SET ANY PUBLIC OPTION |
| sql_flagger_warning_level 选项 | Off、SQL:1992/Entry、SQL:1992/Intermediate、SQL:1992/Full、SQL:1999/Core、SQL:1999/Package、SQL:2003/Core、SQL:2003/Package、UltraLite | Off | SET ANY PUBLIC OPTION |
| string_rtruncation 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| st_geometry_asbinary_format 选项 | 此选项支持的值列表与为 ST_Geometry 类型的 ST_AsBinary 方法记录的参数列表相同。请参见类型 ST_Geometry 的 ST_AsBinary 方法。 | WKB | SET ANY PUBLIC OPTION |
| st_geometry_astext_format 选项 | 此选项支持的值列表与为 ST_Geometry 类型的 ST_AsText 方法记录的参数列表相同。请参见类型 ST_Geometry 的 ST_AsText 方法。 | WKT | SET ANY PUBLIC OPTION |
| st_geometry_asxml_format 选项 | 此选项支持的值列表与为 ST_Geometry 类型的 ST_AsXML 方法记录的参数列表相同。请参见类型 ST_Geometry 的 ST_AsXML 方法。 | XML | SET ANY PUBLIC OPTION |
| st_geometry_describe_type 选项 | CHAR、NCHAR、BINARY | CHAR | SET ANY PUBLIC OPTION |
| st_geometry_interpolation 选项 | 一组 [键=值] 对，格式为：key1=value1;key2=value2;。有效的键值包括：relative-tolerance-percent=DOUBLE absolute-tolerance=DOUBLE |
有关缺省行为的说明，请参见st_geometry_interpolation 选项。 | SET ANY PUBLIC OPTION |
| st_geometry_on_invalid 选项 | Ignore、Error | Error | SET ANY PUBLIC OPTION |
| subsume_row_locks 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| suppress_tds_debugging 选项 | On、Off | Off | SET ANY PUBLIC OPTION |
| synchronize_mirror_on_commit 选项 | On、Off | Off | SET ANY PUBLIC OPTION |
| tds_empty_string_is_null 选项 | On、Off | Off | SET ANY PUBLIC OPTION |
| temp_space_limit_check 选项 | On、Off | On | SET ANY SYSTEM OPTION |
| time_format 选项 | 字符串 | HH:NN:SS.SSS | SET ANY PUBLIC OPTION |
| time_zone_adjustment 选项 | 放在引号中的整数或负整数，或者是放在引号中的字符串（以小时和分钟表示时间，在 + 或 - 之后） | 根据客户端的连接类型，由客户端或数据库服务器的时区进行设置 | SET ANY PUBLIC OPTION |
| timestamp_format 选项 | 字符串 | YYYY-MM-DD HH:NN:SS.SSS | SET ANY PUBLIC OPTION |
| timestamp_with_time_zone_format 选项 | 字符串 | YYYY-MM-DD HH:NN:SS.SSS+HH:NN | SET ANY PUBLIC OPTION |
| truncate_timestamp_values 选项 | On、Off | Off | SET ANY SYSTEM OPTION |
| trusted_certificates_file 选项 | NULL、'filepath-to-certificate | NULL | SET ANY SECURITY OPTION |
| tsql_outer_joins 选项 | On、Off | Off | SET ANY PUBLIC OPTION |
| tsql_variables 选项 | On、Off |
Off 对 Sybase Open Client 和 jConnect 连接为 On |
SET ANY PUBLIC OPTION |
| updatable_statement_isolation 选项 | 0, 1, 2, 3 | 0 | SET ANY PUBLIC OPTION |
| update_statistics 选项 | On、Off | On | SET ANY PUBLIC OPTION |
| user_estimates 选项 | Enabled、Disabled、Override-Magic | Override-Magic | SET ANY PUBLIC OPTION |
| uuid_has_hyphens 选项 | On、Off | Off | SET ANY PUBLIC OPTION |
| verify_password_function 选项 | 字符串 | 空字符串 | SET ANY SECURITY OPTION |
| wait_for_commit 选项 | On、Off | Off | SET ANY PUBLIC OPTION |
| webservice_namespace_host 选项 | NULL、主机名字符串 | NULL | SET ANY SYSTEM OPTION |
| webservice_sessionid_name 选项 | NULL、sessionid-string | NULL | SET ANY SYSTEM OPTION |
另请参见不同类型的数据库选项
数据库选项的作用域和持续时间
如何查看数据库选项
监控选项设置
更改数据库选项 (Sybase Central)
TDS 和命令序列通信协议的数据库选项设置
按字母顺序排列的数据库选项列表
 |
使用DocCommentXchange讨论此页。
|
版权 © 2013, SAP 股份公司或其关联公司. - SAP Sybase SQL Anywhere 16.0 |