Special Characters
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Index: O
object identifiers:
see
OIDs
Understanding SNMP
objects: qualified names
Database object names and prefixes
obtaining authentication signatures: about
Obtaining authentication signatures
odbc_describe_binary_as_varbinary option: connection property description
Connection-level properties
odbc_describe_binary_as_varbinary option: description
odbc_describe_binary_as_varbinary [database]
odbc_describe_binary_as_varbinary option: SQL Anywhere SNMP Extension Agent OID
SQL Anywhere MIB database options
odbc_distinguish_char_and_varchar option: connection property description
Connection-level properties
odbc_distinguish_char_and_varchar option: description
odbc_distinguish_char_and_varchar option [database]
odbc_distinguish_char_and_varchar option: SQL Anywhere SNMP Extension Agent OID
SQL Anywhere MIB database options
ODBC_INI environment variable: description
ODBCINI and ODBC_INI environment variables [Unix]
ODBC_INI environment variable: locating the system information file
Using ODBC data sources on Unix
ODBC: Administrator
Creating an ODBC data source
ODBC: connection parameters
Connection parameters
ODBC: connections
Introduction to SQL Anywhere database connections
ODBC: data source connection parameters
Data Source utility (dbdsn)
ODBC: data sources
Working with ODBC data sources
ODBC: Delphi
odbc_describe_binary_as_varbinary [database]
ODBC: driver location
Locating the interface library
ODBC: initialization file for Unix
Using ODBC data sources on Unix
ODBC: limited functionality on Windows CE
SQL Anywhere feature support on Windows CE
ODBC: odbc_describe_binary_as_varbinary option
odbc_describe_binary_as_varbinary [database]
ODBC: odbc_distinguish_char_and_varchar option
odbc_distinguish_char_and_varchar option [database]
ODBC: troubleshooting
Ping utility (dbping)
ODBC: Unix support
Using ODBC data sources on Unix
ODBC: using data sources on Windows CE
Using ODBC data sources on Windows CE
ODBC Administrator: using
Creating an ODBC data source
ODBC connection parameters: Delphi
Data Source utility (dbdsn)
ODBC connection parameters: DescribeCursor
Data Source utility (dbdsn)
ODBC connection parameters: Description
Data Source utility (dbdsn)
ODBC connection parameters: Driver
Data Source utility (dbdsn)
ODBC connection parameters: GetTypeInfoChar
Data Source utility (dbdsn)
ODBC connection parameters: InitString
Data Source utility (dbdsn)
ODBC connection parameters: IsolationLevel
Data Source utility (dbdsn)
ODBC connection parameters: KeysInSQLStatistics
Data Source utility (dbdsn)
ODBC connection parameters: LazyAutocommit
Data Source utility (dbdsn)
ODBC connection parameters: PrefetchOnOpen
Data Source utility (dbdsn)
ODBC connection parameters: PreventNotCapable
Data Source utility (dbdsn)
ODBC connection parameters: SuppressWarnings
Data Source utility (dbdsn)
ODBC connection parameters: TranslationDLL
Data Source utility (dbdsn)
ODBC connection parameters: TranslationName
Data Source utility (dbdsn)
ODBC connection parameters: TranslationOption
Data Source utility (dbdsn)
ODBC data sources: about
Working with ODBC data sources
ODBC data sources: configuring
Creating ODBC data sources using the ODBC Administrator
ODBC data sources: creating
Creating an ODBC data source
ODBC data sources: creating for Windows CE
Creating an ODBC data source to connect to your Windows CE device
ODBC data sources: creating on Mac OS X
Creating an ODBC data source on Mac OS X
ODBC data sources: creating with dbdsn
Data Source utility (dbdsn)
ODBC data sources: Unix
Using ODBC data sources on Unix
ODBC driver: setting up
Creating an ODBC data source on Mac OS X
ODBC driver: threaded and non-threaded versions
Creating an ODBC data source on Mac OS X
ODBCHOME environment variable: description
ODBCHOME environment variable [Unix]
ODBCINI environment variable: description
ODBCINI and ODBC_INI environment variables [Unix]
ODBCINI environment variable: locating the system information file
Using ODBC data sources on Unix
ODBC INI file: about
Using ODBC data sources on Unix
ODBC sample: using
The ODBC Sample
ODI: drivers
Ensure that you have current drivers
oem_string option: connection property description
Connection-level properties
oem_string option: description
oem_string option [database]
oem_string option: SQL Anywhere SNMP Extension Agent OID
SQL Anywhere MIB database options
OEM code pages: about
ANSI and OEM code pages in Windows
OEM Edition: about
Running authenticated SQL Anywhere applications
offline backups: about
Ways of making backups
offline backups: defined
Types of backup
OIDs:
see also
object identifiers
About This Manual
OIDs: about
Understanding SNMP
OIDs: database options
SQL Anywhere MIB database options
OIDs: database properties
SQL Anywhere MIB database properties
OIDs: database statistics
SQL Anywhere MIB database statistics
OIDs: defined
Understanding SNMP
OIDs: RDBMS MIB
The RDBMS MIB
OIDs: server properties
SQL Anywhere MIB server properties
OIDs: server statistics
SQL Anywhere MIB server statistics
OIDs: SQL Anywhere MIB
SQL Anywhere MIB Reference
OLAP: optimization_workload option
optimization_workload option [database]
OLE DB: connecting
Connecting to a database using OLE DB
OLE DB: providers
OLE DB providers
OLE DB: SAOLEDB provider
OLE DB providers
OmniConnect support: about
Sybase applications and SQL Anywhere
OmniIdentifier property: server property description
Server-level properties
OmniIdentifier property: SQL Anywhere SNMP Extension Agent OID
SQL Anywhere MIB server properties
on_charset_conversion_failure option: connection property description
Connection-level properties
on_charset_conversion_failure option: description
on_charset_conversion_failure option [database]
on_charset_conversion_failure option: SQL Anywhere SNMP Extension Agent OID
SQL Anywhere MIB database options
on_error option: description
on_error option [Interactive SQL]
on_error option: Interactive SQL settings
Interactive SQL options
on_tsql_error option: ASE compatibility
Compatibility options
on_tsql_error option: connection property description
Connection-level properties
on_tsql_error option: description
on_tsql_error option [compatibility]
on_tsql_error option: Open Client
Characteristics of Open Client and jConnect connections
on_tsql_error option: SQL Anywhere SNMP Extension Agent OID
SQL Anywhere MIB database options
on_tsql_error option: Transact-SQL compatibility
Compatibility options
ON EXCEPTION RESUME clause: on_tsql_error option
on_tsql_error option [compatibility]
online backups: about
Ways of making backups
online backups: defined
Types of backup
online books: PDF
SQL Anywhere documentation
Open Client: ASE compatibility options
Compatibility options
Open Client: configuring
Configuring Open Servers
Open Client: interface
Open Clients, Open Servers, and TDS
Open Client: Kerberos authentication
Setting up Kerberos authentication
Open Client: maximum length of identifiers
Replication Server character set and language issues
Open Client: options
Characteristics of Open Client and jConnect connections
Open Client: unsupported on Windows CE
SQL Anywhere feature support on Windows CE
opening cursors: query_plan_on_open option
query_plan_on_open option [compatibility]
opening multiple Interactive SQL windows: about
Opening multiple windows
Open Server: adding
Configuring Open Servers
Open Server: address
Adding or changing the server address
Open Server: architecture
Open Clients, Open Servers, and TDS
Open Server: configuring servers for JDBC
Configuring servers for JDBC
Open Server: connecting
Lesson 4: Confirm that the Open Servers are configured properly
Open Server: deleting server entries
Deleting server entries
Open Server: renaming server entries
Renaming a server entry
Open Server: starting
Starting the database server as an Open Server
Open Server: system requirements
System requirements
OPEN statement: query_plan_on_open option
query_plan_on_open option [compatibility]
operational servers: about
Introduction to database mirroring
optimistic_wait_for_commit option: connection property description
Connection-level properties
optimistic_wait_for_commit option: description
optimistic_wait_for_commit option [compatibility]
optimistic_wait_for_commit option: SQL Anywhere SNMP Extension Agent OID
SQL Anywhere MIB database options
optimistic_wait_for_commit option: Transact-SQL compatibility
Compatibility options
optimization_goal option: connection property description
Connection-level properties
optimization_goal option: description
optimization_goal option [database]
optimization_goal option: SQL Anywhere SNMP Extension Agent OID
SQL Anywhere MIB database options
optimization_level option: connection property description
Connection-level properties
optimization_level option: description
optimization_level option [database]
optimization_level option: SQL Anywhere SNMP Extension Agent OID
SQL Anywhere MIB database options
optimization_workload option: connection property description
Connection-level properties
optimization_workload option: description
optimization_workload option [database]
optimization_workload option: SQL Anywhere SNMP Extension Agent OID
SQL Anywhere MIB database options
optimizer: bypass
optimization_level option [database]
optimizer: controlling effort used to located access plans
optimization_level option [database]
options: about
Introduction to database options
options: allow_nulls_by_default
allow_nulls_by_default option [compatibility]
options: allow_snapshot_isolation
allow_snapshot_isolation option [database]
options: alphabetical list
Alphabetical list of options
options: ansi_blanks
ansi_blanks option [compatibility]
options: ansi_close_cursors_on_rollback
ansi_close_cursors_on_rollback option [compatibility]
options: ansi_integer_overflow
ansi_integer_overflow option [compatibility]
options: ansi_permissions
ansi_permissions option [compatibility]
options: ansi_substring
ansi_substring option [compatibility]
options: ansi_update_constraints
ansi_update_constraints option [compatibility]
options: ansinull
ansinull option [compatibility]
options: ASE compatibility options
Compatibility options
options: auditing
auditing option [database]
options: auditing_options
auditing_options option [database]
options: auto_commit
auto_commit option [Interactive SQL]
options: auto_refetch
auto_refetch option [Interactive SQL]
options: automatic_timestamp
automatic_timestamp option [compatibility]
options: background_priority
background_priority option [database]
options: backup [dbbackup] utility
Backup utility (dbbackup)
options: bell
bell option [Interactive SQL]
options: blob_threshold
blob_threshold option [SQL Remote]
options: blocking
blocking option [database]
options: blocking_timeout
blocking_timeout option [database]
options: case sensitivity
Setting options
options: chained
chained option [compatibility]
options: checkpoint_time
checkpoint_time option [database]
options: cis_option
cis_option option [database]
options: cis_rowset_size
cis_rowset_size option [database]
options: classification
Option classification
options: close_on_endtrans
close_on_endtrans option [compatibility]
options: collect_statistics_on_dml_updates
collect_statistics_on_dml_updates option [database]
options: command_delimiter
command_delimiter option [Interactive SQL]
options: commit_on_exit
commit_on_exit option [Interactive SQL]
options: compression
compression option [SQL Remote]
options: conn_auditing
conn_auditing option [database]
options: connection_authentication
connection_authentication option [database]
options: continue_after_raiserror
continue_after_raiserror option [compatibility]
options: conversion_error
conversion_error option [compatibility]
options: cooperative_commit_timeout
cooperative_commit_timeout option [database]
options: cooperative_commits
cooperative_commits option [database]
options: createcert
Certificate creation utility [createcert]
options: database_authentication
database_authentication [database]
options: database options in SQL Anywhere MIB
SQL Anywhere MIB database options
options: database server
The SQL Anywhere database server
options: data source [dbdsn] utility
Data Source utility (dbdsn)
options: date_format
date_format option [compatibility]
options: date_order
date_order option [compatibility]
options: dbisqlc utility
Interactive SQL utility (dbisqlc)
options: debug_messages option
debug_messages option [database]
options: dedicated_task
dedicated_task option [database]
options: default_dbspace
default_dbspace option [database]
options: default_isql_encoding
default_isql_encoding option [Interactive SQL]
options: default_timestamp_increment
default_timestamp_increment option [database] [MobiLink client]
options: delayed_commit_timeout
delayed_commit_timeout option [database]
options: delayed_commits
delayed_commits option [database]
options: delete_old_logs
delete_old_logs option [MobiLink client] [SQL Remote] [Replication Agent]
options: deleting settings
Deleting option settings
options: divide_by_zero_error
divide_by_zero_error option [compatibility]
options: echo
echo option [Interactive SQL]
options: encrypt_aes_random_iv
encrypt_aes_random_iv option [database]
options: erase [dberase] utility
Erase utility (dberase)
options: escape_character
escape_character option [compatibility]
options: exclude_operators
exclude_operators option [database]
options: finding values
Finding option settings
options: fire_triggers
fire_triggers option [compatibility]
options: first_day_of_week
first_day_of_week option [database]
options: float_as_double
float_as_double option [compatibility]
options: for_xml_null_treatment
for_xml_null_treatment option [database]
options: force_view_creation
force_view_creation option [database]
options: global_database_id
global_database_id option [database]
options: histogram [dbhist] utility
Histogram utility (dbhist)
options: http_session_timeout
http_session_timeout option [database]
options: information [dbinfo] utility
Information utility (dbinfo)
options: initialization [dbinit] utility
Initialization utility (dbinit)
options: initial settings
Initial option settings
options: input_format
input_format option [Interactive SQL]
options: integrated_server_name
integrated_server_name option [database]
options: Interactive SQL [dbisql] utility
Interactive SQL utility (dbisql)
options: Interactive SQL options
Interactive SQL options
options: isolation_level
isolation_level option [compatibility]
options: isql_command_timing
isql_command_timing option [Interactive SQL]
options: isql_escape_character
isql_escape_character option [Interactive SQL]
options: isql_field_separator
isql_field_separator option [Interactive SQL]
options: isql_maximum_displayed_rows
isql_maximum_displayed_rows option [Interactive SQL]
options: isql_plan
isql_plan option [Interactive SQL]
options: isql_print_result_set
isql_print_result_set option [Interactive SQL]
options: isql_quote
isql_quote option [Interactive SQL]
options: isql_show_multiple_result_sets
isql_show_multiple_result_sets [Interactive SQL]
options: java_location
java_location option [database]
options: java_main_userid
java_main_userid option [database]
options: java_vm_options
java_vm_options option [database]
options: language selection [dblang] utility
Language Selection utility (dblang)
options: Linux service [dbsvc] utility
Service utility (dbsvc) for Linux
options: list of database options
Database options
options: log_deadlocks
log_deadlocks option [database]
options: login_mode
login_mode option [database]
options: login_procedure
login_procedure option [database]
options: log transfer manager utility [dbltm] utility
Log Transfer Manager utility (dbltm)
options: log translation [dbtran] utility
Log Translation utility (dbtran)
options: materialized_view_optimization
materialized_view_optimization option [database]
options: max_client_statements_cached
max_client_statements_cached option [database]
options: max_cursor_count
max_cursor_count option [database]
options: max_plans_cached
max_plans_cached option [database]
options: max_query_tasks
max_query_tasks option [database]
options: max_recursive_iterations
max_recursive_iterations option [database]
options: max_statement_count
max_statement_count option [database]
options: max_temp_space
max_temp_space option [database]
options: min_password_length
min_password_length option [database]
options: MobiLink certificate creation [createcert]
Certificate creation utility [createcert]
options: MobiLink certificate viewer [viewcert] utility
Certificate viewer utility [viewcert]
options: nearest_century option
nearest_century option [compatibility]
options: non_keywords
non_keywords option [compatibility]
options: nulls
nulls option [Interactive SQL]
options: odbc_describe_binary_as_varbinary
odbc_describe_binary_as_varbinary [database]
options: odbc_distinguish_char_and_varchar
odbc_distinguish_char_and_varchar option [database]
options: oem_string
oem_string option [database]
options: on_charset_conversion_failure
on_charset_conversion_failure option [database]
options: on_error
on_error option [Interactive SQL]
options: on_tsql_error
on_tsql_error option [compatibility]
options: Open Client
Characteristics of Open Client and jConnect connections
options: optimistic_wait_for_commit
optimistic_wait_for_commit option [compatibility]
options: optimization_goal
optimization_goal option [database]
options: optimization_level
optimization_level option [database]
options: optimization_workload
optimization_workload option [database]
options: output_format
output_format option [Interactive SQL]
options: output_length
output_length option [Interactive SQL]
options: output_nulls
output_nulls option [Interactive SQL]
options: percent_as_comment
percent_as_comment option [compatibility]
options: ping [dbping] utility
Ping utility (dbping)
options: pinned_cursor_percent_of_cache
pinned_cursor_percent_of_cache option [database]
options: post_login_procedure
post_login_procedure [database]
options: precision
precision option [database]
options: prefetch
prefetch option [database]
options: preserve_source_format
preserve_source_format option [database]
options: prevent_article_pkey_update
prevent_article_pkey_update option [database] [MobiLink client]
options: PUBLIC options
Scope and duration of database options
options: qualify_owners
qualify_owners option [SQL Remote]
options: query_plan_on_open
query_plan_on_open option [compatibility]
options: quote_all_identifiers
quote_all_identifiers option [SQL Remote]
options: quoted_identifier
quoted_identifier option [compatibility]
options: read_past_deleted
read_past_deleted option [database]
options: recovery_time
recovery_time option [database]
options: remote_idle_timeout
remote_idle_timeout option [database]
options: replicate_all
replicate_all option [Replication Agent]
options: replication_error
replication_error option [SQL Remote]
options: replication_error_piece
replication_error_piece option [SQL Remote]
options: replication options
SQL Remote options
options: request_timeout
request_timeout option [database]
options: return_date_time_as_string
return_date_time_as_string option [database]
options: ri_trigger_time
ri_trigger_time option [compatibility]
options: rollback_on_deadlock
rollback_on_deadlock [database]
options: row_counts
row_counts option [database]
options: scale
scale option [database]
options: scope and duration of database options
Scope and duration of database options
options: secure_feature_key
secure_feature_key [database]
options: server enumeration [dblocate] utility
Server Enumeration utility (dblocate)
options: server licensing [dblic] utility
Server Licensing utility (dblic)
options: setting database options
Setting options
options: setting for SQL Anywhere MobiLink clients
Synchronization options
options: setting in Interactive SQL
Interactive SQL options
options: setting temporary
Scope and duration of database options
options: setting user and group options
Setting user and group options
options: sort_collation
sort_collation option [database]
options: sql_flagger_error_level
sql_flagger_error_level option [compatibility]
options: sql_flagger_warning_level
sql_flagger_warning_level option [compatibility]
options: SQL Anywhere broadcast repeater [dbns10] utility
SQL Anywhere Broadcast Repeater utility (dbns10)
options: SQL Anywhere console [dbconsole] utility
SQL Anywhere Console utility (dbconsole)
options: SQL Anywhere script execution [dbrunsql] utility
SQL Anywhere Script Execution utility (dbrunsql)
options: SQL Anywhere support [dbsupport] syntax
SQL Anywhere Support utility (dbsupport)
options: sr_date_format
sr_date_format option [SQL Remote]
options: sr_time_format
sr_time_format option [SQL Remote]
options: sr_timestamp_format
sr_timestamp_format [SQL Remote]
options: start server in background [dbspawn] utility
Start Server in Background utility (dbspawn)
options: startup settings
Characteristics of Open Client and jConnect connections
options: stop server [dbstop] utility
Stop Server utility (dbstop)
options: string_rtruncation
string_rtruncation option [compatibility]
options: subscribe_by_remote
subscribe_by_remote option [SQL Remote]
options: subsume_row_locks
subsume_row_locks option [database]
options: suppress_tds_debugging
suppress_tds_debugging option [database]
options: synchronize_mirror_on_commit
synchronize_mirror_on_commit option [database]
options: tds_empty_string_is_null
tds_empty_string_is_null option [database]
options: temp_space_limit_check
temp_space_limit_check option [database]
options: time_format
time_format option [compatibility]
options: time_zone_adjustment
time_zone_adjustment option [database]
options: timestamp_format
timestamp_format option [compatibility]
options: transaction log [dblog] utility
Transaction Log utility (dblog)
options: Transact-SQL compatibility options
Compatibility options
options: truncate_timestamp_values
truncate_timestamp_values option [database] [MobiLink client]
options: truncate_with_auto_commit
truncate_with_auto_commit option [database]
options: truncation_length
truncation_length option [Interactive SQL]
options: tsql_hex_constant
tsql_hex_constant option [compatibility]
options: tsql_outer_joins
tsql_outer_joins option [compatibility]
options: tsql_variables
tsql_variables option [compatibility]
options: unload [dbunload] utility
Unload utility (dbunload)
options: updatable_statement_isolation
updatable_statement_isolation option [database]
options: update_statistics
update_statistics option [database]
options: upgrade [dbupgrad] utility
Upgrade utility (dbupgrad)
options: user_estimates
user_estimates option [database]
options: uuid_has_hyphens
uuid_has_hyphens option [database]
options: validation [dbvalid] utility
Validation utility (dbvalid)
options: verify_all_columns
verify_all_columns option [SQL Remote]
options: verify_password_function
verify_password_function option [database]
options: verify_threshold
verify_threshold option [SQL Remote]
options: viewcert utility
Certificate viewer utility [viewcert]
options: wait_for_commit
wait_for_commit option [database]
options: webservice_namespace_host
webservice_namespace_host option [database]
options: Windows service [dbsvc] utility
Service utility (dbsvc) for Windows
Oracle driver: creating data sources
Data Source utility (dbdsn)
organization unit: verifying in MobiLink transport-layer security
Verifying certificate fields
os_charset alias: about
Supported character sets
output_format option: description
output_format option [Interactive SQL]
output_format option: Interactive SQL settings
Interactive SQL options
output_length option: description
output_length option [Interactive SQL]
output_length option: Interactive SQL settings
Interactive SQL options
output_nulls option: description
output_nulls option [Interactive SQL]
output_nulls option: Interactive SQL settings
Interactive SQL options
Override-Magic: user_estimates option
user_estimates option [database]
owners: about
Ownership permissions overview