The following options allow you to configure the behavior of a SQL Anywhere database.
| Option | Values | Default | Required Privilege |
|---|---|---|---|
| allow_nulls_by_default option | On, Off |
On Off for Sybase Open Client and jConnect connections |
SET ANY PUBLIC OPTION |
| allow_read_client_file option | On, Off | Off | SET ANY SECURITY OPTION |
| allow_snapshot_isolation option | On, Off | Off | SET ANY SYSTEM OPTION |
| allow_write_client_file option | On, Off | Off | SET ANY SECURITY OPTION |
| ansi_blanks option | On, Off | Off | SET ANY PUBLIC OPTION |
| ansi_close_cursors_on_rollback option | On, Off | Off | SET ANY PUBLIC OPTION |
| ansi_permissions option | On, Off | On | SET ANY SYSTEM OPTION |
| ansi_substring option | On, Off | On | SET ANY PUBLIC OPTION |
| ansi_update_constraints option | Off, Cursors, Strict | Cursors | SET ANY PUBLIC OPTION |
| ansinull option | On, Off | On | SET ANY PUBLIC OPTION |
| auditing option | On, Off | Off | SET ANY SECURITY OPTION |
| auditing_options option (reserved for system use) | Reserved | Reserved | SET ANY SECURITY OPTION |
| auto_commit_on_create_local_temp_index option | On, Off | Off | SET ANY SYSTEM OPTION |
| background_priority option [deprecated] | On, Off | Off | SET ANY PUBLIC OPTION |
| blocking option | On, Off | On | SET ANY PUBLIC OPTION |
| blocking_others_timeout option | Integer, in milliseconds | 0 | SET ANY PUBLIC OPTION |
| blocking_timeout option | Integer, in milliseconds | 0 | SET ANY PUBLIC OPTION |
| chained option | On, Off |
On Off for Sybase Open Client and jConnect connections |
SET ANY PUBLIC OPTION |
| checkpoint_time option | Number of minutes | 60 | SET ANY SYSTEM OPTION |
| cis_option option | 0, 7 | 0 | SET ANY PUBLIC OPTION |
| cis_rowset_size option | Integer | 50 | SET ANY PUBLIC OPTION |
| close_on_endtrans option | On, Off |
On Off for jConnect connections |
SET ANY PUBLIC OPTION |
| collect_statistics_on_dml_updates option | On, Off | On | SET ANY PUBLIC OPTION |
| conn_auditing option | On, Off | On | SET ANY SECURITY OPTION |
| connection_authentication option | String | Empty string | SET ANY PUBLIC OPTION |
| continue_after_raiserror option | On, Off | On | SET ANY PUBLIC OPTION |
| conversion_error option | On, Off | On | SET ANY PUBLIC OPTION |
| cooperative_commit_timeout option | Integer, in milliseconds | 250 | SET ANY PUBLIC OPTION |
| cooperative_commits option | On, Off | On | SET ANY PUBLIC OPTION |
| database_authentication option | String | Empty string | SET ANY SECURITY OPTION |
| date_format option | String | YYYY-MM-DD | SET ANY PUBLIC OPTION |
| date_order option | MDY, YMD, DMY | YMD | SET ANY PUBLIC OPTION |
| db_publisher option | User ID | -1 | SET ANY SYSTEM OPTION |
| debug_messages option | On, Off | Off | SET ANY PUBLIC OPTION |
| dedicated_task option | On, Off | Off | SET ANY SYSTEM OPTION |
| default_dbspace option | String | Empty string (use the system dbspace) | SET ANY PUBLIC OPTION |
| default_timestamp_increment option | Integer, representing microseconds, from 1 to 1000000 | 1 | SET ANY PUBLIC OPTION |
| delayed_commit_timeout option | Integer, in milliseconds | 500 | SET ANY PUBLIC OPTION |
| delayed_commits option | On, Off | Off | SET ANY PUBLIC OPTION |
| disk_sandbox option | On, Off | Off | SET ANY SECURITY OPTION |
| divide_by_zero_error option | On, Off | On | SET ANY PUBLIC OPTION |
| escape_character option | Reserved | Reserved | SET ANY PUBLIC OPTION |
| exclude_operators option | Reserved | Reserved | SET ANY SYSTEM OPTION |
| extended_join_syntax option | On, Off | On | SET ANY PUBLIC OPTION |
| extern_login_credentials option | Login_user, Effective_user | Login_user | SET ANY SECURITY OPTION |
| fire_triggers option | On, Off | On | SET ANY SYSTEM OPTION |
| first_day_of_week option | 1, 2, 3, 4, 5, 6, 7 | 7 (Sunday is the first day of the week) | SET ANY PUBLIC OPTION |
| for_xml_null_treatment option | Empty, Omit | Omit | SET ANY PUBLIC OPTION |
| force_view_creation option | Reserved | Reserved | SET ANY SYSTEM OPTION |
| global_database_id option | Integer | 2147483647 | SET ANY SYSTEM OPTION |
| http_connection_pool_basesize option | Integer (from 0 to 1000) | 10 | SET ANY SYSTEM OPTION |
| http_connection_pool_timeout option | Integer, in seconds from 1 to 86400 | 60 | SET ANY SYSTEM OPTION |
| http_session_timeout option | Integer | 30 | SET ANY PUBLIC OPTION |
| integrated_server_name option | String | NULL | SET ANY SECURITY OPTION |
| isolation_level option | 0, 1, 2, 3, Snapshot, Statement-snapshot, Readonly-statement-snapshot | 0 | SET ANY PUBLIC OPTION |
| java_class_path option | String | Empty string | SET ANY SYSTEM OPTION |
| java_location option | String | Empty string | SET ANY SYSTEM OPTION |
| java_main_userid option (deprecated | String | Empty string | SET ANY SYSTEM OPTION |
| java_vm_options option | String | Empty string | SET ANY SYSTEM OPTION |
| log_deadlocks option | On, Off | Off | SET ANY SYSTEM OPTION |
| login_mode option | Standard, Integrated, Kerberos, LDAPUA, CloudAdmin, Mixed (deprecated) | Standard | SET ANY SECURITY OPTION |
| login_procedure option | String | sp_login_environment | SET ANY SECURITY OPTION |
| materialized_view_optimization option | Disabled, Fresh, Stale, N { Minute[s] | Hour[s] | Day[s] | Week[s] | Month[s] } | Stale | SET ANY PUBLIC OPTION |
| max_client_statements_cached option | Integer | 10 | SET ANY PUBLIC OPTION |
| max_cursor_count option | Integer | 50 | SET ANY SYSTEM OPTION |
| max_plans_cached option | Integer | 20 | SET ANY PUBLIC OPTION |
| max_priority option | Critical, High, Above Normal, Normal, Below normal, Low, Background | Normal | SET ANY SYSTEM OPTION |
| max_query_tasks option | Integer | 0 | SET ANY PUBLIC OPTION |
| max_recursive_iterations option | Integer | 100 | SET ANY PUBLIC OPTION |
| max_statement_count option | Integer >=0 | 50 | SET ANY SYSTEM OPTION |
| max_temp_space option | Integer [k|m|g|p] | 0 | SET ANY SYSTEM OPTION |
| min_password_length option | Integer >=0 | 0 characters | SET ANY SECURITY OPTION |
| min_role_admins option | Integer, between 1 and 10 inclusive | 1 | SET ANY SECURITY OPTION |
| nearest_century option | Integer, between 0 and 100 inclusive | 50 | SET ANY PUBLIC OPTION |
| non_keywords option | String | Empty string | SET ANY PUBLIC OPTION |
| odbc_describe_binary_as_varbinary | On, Off | Off | SET ANY PUBLIC OPTION |
| odbc_distinguish_char_and_varchar option | On, Off | Off | SET ANY PUBLIC OPTION |
| oem_string option | String (up to 128 bytes) | Empty string | SET ANY SYSTEM OPTION |
| on_charset_conversion_failure option | Ignore, Warning, Error | Ignore | SET ANY PUBLIC OPTION |
| on_tsql_error option | Stop, Conditional, Continue |
Conditional Continue for jConnect connections |
SET ANY PUBLIC OPTION |
| optimization_goal option | First-row or All-rows | All-rows | SET ANY PUBLIC OPTION |
| optimization_level option | 0-15 | 9 | SET ANY PUBLIC OPTION |
| optimization_workload option | Mixed, OLAP | Mixed | SET ANY SYSTEM OPTION |
| pinned_cursor_percent_of_cache option | Integer, between 0-100 | 10 | SET ANY SYSTEM OPTION |
| post_login_procedure option | String | Empty string | SET ANY SECURITY OPTION |
| precision option | Integer, between 1 and 127 inclusive | 30 | SET ANY PUBLIC OPTION |
| prefetch option | Off, Conditional, Always | Conditional | SET ANY PUBLIC OPTION |
| preserve_source_format option | On, Off | On | SET ANY SYSTEM OPTION |
| prevent_article_pkey_update option | On, Off | On | SET ANY PUBLIC OPTION |
| priority option | Critical, High, Above Normal, Normal, Below normal, Low, Background | Normal | SET ANY PUBLIC OPTION |
| progress_messages option | Off, Formatted, Raw | Off | SET ANY PUBLIC OPTION |
| query_mem_timeout option | -1, 0, positive integer | -1 | SET ANY PUBLIC OPTION |
| quoted_identifier option | On, Off | On | SET ANY PUBLIC OPTION |
| read_past_deleted option | On, Off | On | SET ANY PUBLIC OPTION |
| recovery_time option | Integer, in minutes | 2 | SET ANY SYSTEM OPTION |
| remote_idle_timeout option | Integer, in seconds | 15 | SET ANY PUBLIC OPTION |
| request_timeout option | Integer, 0 through 86400, in seconds | 0 | SET ANY PUBLIC OPTION |
| reserved_keywords option | String | Empty string | SET ANY SYSTEM OPTION |
| return_date_time_as_string option | On, Off | Off | SET ANY PUBLIC OPTION |
| rollback_on_deadlock | On, Off | On | SET ANY PUBLIC OPTION |
| row_counts option | On, Off | Off | SET ANY PUBLIC OPTION |
| scale option | Integer, between 0 and 127, inclusive, and less than the value specified for the precision database option | 6 | SET ANY PUBLIC OPTION |
| String | NULL | SET ANY PUBLIC OPTION | |
| sort_collation option | Internal, collation_name, or collation_id | Internal | SET ANY PUBLIC OPTION |
| sql_flagger_error_level option | 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 option | 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 option | On, Off | On | SET ANY PUBLIC OPTION |
| st_geometry_asbinary_format option | The list of values supported for this option is identical to the list of parameters documented for the ST_AsBinary method for type ST_Geometry. See ST_AsBinary method for type ST_Geometry. | WKB | SET ANY PUBLIC OPTION |
| st_geometry_astext_format option | The list of values supported for this option is identical to the list of parameters documented for the ST_AsText method for type ST_Geometry. See ST_AsText method for type ST_Geometry. | WKT | SET ANY PUBLIC OPTION |
| st_geometry_asxml_format option | The list of values supported for this option is identical to the list of parameters documented for the ST_AsXML method for type ST_Geometry. See ST_AsXML method for type ST_Geometry. | XML | SET ANY PUBLIC OPTION |
| st_geometry_describe_type option | CHAR, NCHAR, BINARY | CHAR | SET ANY PUBLIC OPTION |
| st_geometry_interpolation option | A set of key=value pairs, formatted as: key1=value1;key2=value2;. Valid keys include: relative-tolerance-percent=DOUBLE absolute-tolerance=DOUBLE |
See the description of the defaulting behavior found in st_geometry_interpolation option. | SET ANY PUBLIC OPTION |
| st_geometry_on_invalid option | Ignore, Error | Error | SET ANY PUBLIC OPTION |
| subsume_row_locks option | On, Off | On | SET ANY PUBLIC OPTION |
| suppress_tds_debugging option | On, Off | Off | SET ANY PUBLIC OPTION |
| synchronize_mirror_on_commit option | On, Off | Off | SET ANY PUBLIC OPTION |
| tds_empty_string_is_null option | On, Off | Off | SET ANY PUBLIC OPTION |
| temp_space_limit_check option | On, Off | On | SET ANY SYSTEM OPTION |
| time_format option | String | HH:NN:SS.SSS | SET ANY PUBLIC OPTION |
| time_zone_adjustment option | Integer, or negative integer enclosed in quotation marks, or string, representing time in hours and minutes, preceded by + or -, enclosed in quotation marks | Set by either the client's or the database server's time zone, depending on the client's connection type | SET ANY PUBLIC OPTION |
| timestamp_format option | String | YYYY-MM-DD HH:NN:SS.SSS | SET ANY PUBLIC OPTION |
| timestamp_with_time_zone_format option | String | YYYY-MM-DD HH:NN:SS.SSS+HH:NN | SET ANY PUBLIC OPTION |
| truncate_timestamp_values option | On, Off | Off | SET ANY SYSTEM OPTION |
| trusted_certificates_file option | NULL, 'filepath-to-certificate | NULL | SET ANY SECURITY OPTION |
| tsql_outer_joins option | On, Off | Off | SET ANY PUBLIC OPTION |
| tsql_variables option | On, Off |
Off On for Sybase Open Client and jConnect connections |
SET ANY PUBLIC OPTION |
| updatable_statement_isolation option | 0, 1, 2, 3 | 0 | SET ANY PUBLIC OPTION |
| update_statistics option | On, Off | On | SET ANY PUBLIC OPTION |
| user_estimates option | Enabled, Disabled, Override-Magic | Override-Magic | SET ANY PUBLIC OPTION |
| uuid_has_hyphens option | On, Off | Off | SET ANY PUBLIC OPTION |
| verify_password_function option | String | Empty string | SET ANY SECURITY OPTION |
| wait_for_commit option | On, Off | Off | SET ANY PUBLIC OPTION |
| webservice_namespace_host option | NULL, hostname-string | NULL | SET ANY SYSTEM OPTION |
| webservice_sessionid_name option | NULL, sessionid-string | NULL | SET ANY SYSTEM OPTION |
See alsoDifferent types of database options
Scope and duration of database options
How to view database options
Monitoring option settings
Changing database options (Sybase Central)
Database option settings for TDS and Command Sequence communication protocols
Alphabetical list of database options
 |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0 |