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

SAP Sybase SQL Anywhere 16.0 (中文) » SQL Anywhere 服务器 - 数据库管理 » 数据库配置

 

数据库选项

利用以下选项,您可以配置 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

secure_feature_key 选项(不建议使用)

字符串 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 和命令序列通信协议的数据库选项设置
按字母顺序排列的数据库选项列表