Index
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 

O

objects: qualified names Database object names and prefixes
ODBC Administrator: using Creating an ODBC data source
ODBC connectivity Specifying a driver for your connection
ODBC data sources: about Saving connection parameters in ODBC data sources
ODBC data sources: configuring Configuring ODBC data sources using the ODBC Administrator
ODBC data sources: creating Creating an ODBC data source
Creating an ODBC data source
Creating an ODBC data source
ODBC data sources: creating with dbdsn The Data Source utility
ODBC data sources: UNIX Using ODBC data sources on UNIX
ODBC data sources: using with jConnect Specifying a driver for your connection
ODBC: Administrator Creating an ODBC data source
ODBC: connection parameters Connection parameters
Connection parameters
ODBC: connections Introduction to connections
ODBC: data sources Working with ODBC data sources
ODBC: driver location Locating the interface library
ODBC: initialization file for UNIX Using ODBC data sources on UNIX
ODBC: troubleshooting The Ping utility
ODBC: UNIX support Using ODBC data sources on UNIX
ODBC: Windows CE Using ODBC data sources on Windows CE
ODI: drivers Ensure that you have current drivers
OEM code pages: about ANSI and OEM code pages in Windows
OEM code pages: choosing ANSI or OEM?
offline backups Ways of making backups
offline backups: defined Types of backup
OLE DB: ASAProv provider OLE DB providers
OLE DB: connecting Connecting to a database using OLE DB
OLE DB: providers OLE DB providers
OmniConnect support Sybase applications and Adaptive Server Anywhere
ON EXCEPTION RESUME clause: stored procedures ON_TSQL_ERROR option [compatibility]
online backups Ways of making backups
online backups: defined Types of backup
ON_CHARSET_CONVERSION_FAILURE option ON_CHARSET_CONVERSION_FAILURE option [database]
ON_CHARSET_CONVERSION_FAILURE option: setting Database options
ON_ERROR option: description ON_ERROR option [ISQL]
ON_ERROR option: Interactive SQL settings Interactive SQL options
ON_TSQL_ERROR option: compatibility option Compatibility options
Compatibility options
ON_TSQL_ERROR option: description ON_TSQL_ERROR option [compatibility]
ON_TSQL_ERROR option: obtaining value Connection-level properties
Open Client: compatibility options Compatibility options
Open Client: configuring Configuring Open Servers
Open Client: interface Open Clients, Open Servers, and TDS
Open Client: options Characteristics of Open Client and jConnect connections
Open Server: adding Configuring Open Servers
Lesson 3: Set up the Open Servers in your system
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 to Lesson 4: Confirm 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]
opening cursors QUERY_PLAN_ON_OPEN option [compatibility]
OPTIMISTIC_WAIT_FOR_COMMIT option: description OPTIMISTIC_WAIT_FOR_COMMIT
OPTIMIZATION_GOAL option: description OPTIMIZATION_GOAL option [database]
OPTIMIZATION_GOAL option: setting Database options
Optimization_goal property: description Connection-level properties
Optimization_level property: description Connection-level properties
options: about Introduction to database options
options: ALLOW_NULLS_BY_DEFAULT ALLOW_NULLS_BY_DEFAULT option [compatibility]
options: ANSINULL ANSINULL option [compatibility]
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_UPDATE_CONSTRAINTS ANSI_UPDATE_CONSTRAINTS option [compatibility]
options: AUDITING AUDITING option [database]
options: AUTOMATIC_TIMESTAMP AUTOMATIC_TIMESTAMP option [compatibility]
options: AUTO_COMMIT AUTO_COMMIT option [ISQL]
options: AUTO_REFETCH AUTO_REFETCH option [ISQL]
options: BACKGROUND_PRIORITY BACKGROUND_PRIORITY option [database]
options: backup [dbbackup] utility Backup utility options
options: BELL BELL option [ISQL]
options: BLOB_THRESHOLD BLOB_THRESHOLD option [replication]
options: BLOCKING BLOCKING option [database]
options: BLOCKING_TIMEOUT BLOCKING_TIMEOUT option [database]
options: CHAINED CHAINED option [compatibility]
options: CHECKPOINT_TIME CHECKPOINT_TIME 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: collation [dbcollat] utility Collation utility options
options: COMMAND_DELIMITER COMMAND_DELIMITER option [ISQL]
options: COMMIT_ON_EXIT COMMIT_ON_EXIT option [ISQL]
options: compatibility Compatibility options
options: COMPRESSION COMPRESSION option [replication]
options: compression [dbshrink] utility Compression utility options
options: console [dbconsole] utility Console utility options
options: CONTINUE_AFTER_RAISERROR CONTINUE_AFTER_RAISERROR option [compatibility]
options: CONVERSION_ERROR CONVERSION_ERROR option [compatibility]
options: COOPERATIVE_COMMITS COOPERATIVE_COMMITS option [database]
options: COOPERATIVE_COMMIT_TIMEOUT COOPERATIVE_COMMIT_TIMEOUT option [database]
options: data source [dbdsn] utility Data Source utility options
options: database server The database server
options: DATE_FORMAT DATE_FORMAT option [compatibility]
options: DATE_ORDER DATE_ORDER option [compatibility]
options: DEFAULT_TIMESTAMP_INCREMENT DEFAULT_TIMESTAMP_INCREMENT option [database]
options: DELAYED_COMMITS DELAYED_COMMITS option [database]
options: DELAYED_COMMIT_TIMEOUT DELAYED_COMMIT_TIMEOUT option [database]
options: DELETE_OLD_LOGS DELETE_OLD_LOGS option [replication]
options: deleting settings Deleting option settings
options: DESCRIBE_JAVA_FORMAT DESCRIBE_JAVA_FORMAT option [ISQL]
options: DIVIDE_BY_ZERO_ERROR DIVIDE_BY_ZERO_ERROR option [compatibility]
options: ECHO ECHO option [ISQL]
options: erase [dberase] utility Erase utility options
options: ESCAPE_CHARACTER ESCAPE_CHARACTER option [compatibility]
EXTENDED_JOIN_SYNTAX option [database]
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: GLOBAL_DATABASE_ID GLOBAL_DATABASE_ID option [database]
options: histogram [dbhist] utility Histogram utility options
options: information [dbinfo] utility Information utility options
options: initial settings Initial option settings
options: initialization [dbinit] utility Initialization utility options
options: INPUT_FORMAT INPUT_FORMAT option [ISQL]
options: Interactive SQL Interactive SQL options
options: Interactive SQL [dbisql] utility Interactive SQL utility options
options: ISOLATION_LEVEL ISOLATION_LEVEL option [compatibility]
options: ISQL_COMMAND_TIMING ISQL_COMMAND_TIMING option [ISQL]
options: ISQL_ESCAPE_CHARACTER ISQL_ESCAPE_CHARACTER option [ISQL]
options: ISQL_FIELD_SEPARATOR ISQL_FIELD_SEPARATOR option [ISQL]
options: ISQL_LOG ISQL_LOG option [ISQL]
options: ISQL_PLAN ISQL_PLAN option [ISQL]
options: ISQL_PRINT_RESULT_SET ISQL_PRINT_RESULT_SET option [ISQL]
options: ISQL_QUOTE ISQL_QUOTE option [ISQL]
options: JAVA_HEAP_SIZE JAVA_HEAP_SIZE option [database]
options: JAVA_INPUT_OUTPUT JAVA_INPUT_OUTPUT option [database]
options: JAVA_NAMESPACE_SIZE JAVA_NAMESPACE_SIZE option [database]
options: language [dblang] utility Language utility options
options: license [dblic] utility License utility options
options: list of all Alphabetical list of options
options: list of compatibility options Compatibility options
Compatibility options
options: list of database options Database options
options: list of Interactive SQL options Interactive SQL options
options: list of replication options Replication options
options: log transfer manager [dbltm] utility Log Transfer Manager utility options
options: log translation [dbtran] utility Log translation utility options
options: LOGIN_MODE LOGIN_MODE option [database]
options: LOGIN_PROCEDURE LOGIN_PROCEDURE option [database]
options: MAX_CURSOR_COUNT MAX_CURSOR_COUNT option [database]
options: MAX_HASH_SIZE MAX_HASH_SIZE option [database]
options: MAX_PLANS_CACHED MAX_PLANS_CACHED option [database]
options: MAX_RECURSIVE_ITERATIONS MAX_RECURSIVE_ITERATIONS [database]
options: MAX_STATEMENT_COUNT MAX_STATEMENT_COUNT option [database]
options: MAX_WORK_TABLE_HASH_SIZE MAX_WORK_TABLE_HASH_SIZE option [database]
options: MIN_PASSWORD_LENGTH MIN_PASSWORD_LENGTH option [database]
options: MIN_TABLE_SIZE_FOR_HISTOGRAM MIN_TABLE_SIZE_FOR_HISTOGRAM option [database]
options: NEAREST_CENTURY option NEAREST_CENTURY option [compatibility]
options: NON_KEYWORDS NON_KEYWORDS option [compatibility]
options: NULLS NULLS option [ISQL]
options: ON_CHARSET_CONVERSION_FAILURE ON_CHARSET_CONVERSION_FAILURE option [database]
options: ON_ERROR ON_ERROR option [ISQL]
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
options: OPTIMIZATION_GOAL OPTIMIZATION_GOAL option [database]
options: OUTPUT_FORMAT OUTPUT_FORMAT option [ISQL]
options: OUTPUT_LENGTH OUTPUT_LENGTH option [ISQL]
options: OUTPUT_NULLS OUTPUT_NULLS option [ISQL]
options: PERCENT_AS_COMMENT PERCENT_AS_COMMENT option [compatibility]
options: ping [dbping] utility Ping utility options
options: PINNED_CURSOR_PERCENT_OF_CACHE PINNED_CURSOR_PERCENT_OF_CACHE option [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]
options: PUBLIC options Setting public options
options: QUALIFY_OWNERS QUALIFY_OWNERS option [replication]
options: QUERY_PLAN_ON_OPEN QUERY_PLAN_ON_OPEN option [compatibility]
options: QUOTED_IDENTIFIER QUOTED_IDENTIFIER option [compatibility]
options: QUOTE_ALL_IDENTIFIERS QUOTE_ALL_IDENTIFIERS option [replication]
options: READ_PAST_DELETED READ_PAST_DELETED option [database]
options: RECOVERY_TIME RECOVERY_TIME option [database]
options: REPLICATE_ALL REPLICATE_ALL option [replication]
options: REPLICATION_ERROR REPLICATION_ERROR option [replication]
options: REPLICATION_ERROR_PIECE REPLICATION_ERROR_PIECE option [replication]
options: RETURN_DATE_TIME_AS_STRING RETURN_DATE_TIME_AS_STRING option [database]
options: RETURN_JAVA_AS_STRING RETURN_JAVA_AS_STRING option [database]
options: RI_TRIGGER_TIME RI_TRIGGER_TIME option [compatibility]
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: server location [dblocate] utility Server location utility options
options: service creation [dbsvc] utility Service creation utility options
options: setting database options Setting 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: spawn [dbspawn] utility Spawn utility options
options: SQL_FLAGGER_ERROR_LEVEL SQL_FLAGGER_ERROR_LEVEL option [compatibility]
options: SQL_FLAGGER_WARNING_LEVEL SQL_FLAGGER_WARNING_LEVEL option [compatibility]
options: startup settings Characteristics of Open Client and jConnect connections
options: STATISTICS STATISTICS option [ISQL]
options: stop [dbstop] utility Stop utility options
options: STRING_RTRUNCATION STRING_RTRUNCATION option [compatibility]
options: SUBSCRIBE_BY_REMOTE SUBSCRIBE_BY_REMOTE option [replication]
options: SUBSUME_ROW_LOCKS SUBSUME_ROW_LOCKS option [database]
options: SUPPRESS_TDS_DEBUGGING SUPPRESS_TDS_DEBUGGING option [database]
options: TDS_EMPTY_STRING_IS_NULL TDS_EMPTY_STRING_IS_NULL option [database]
options: TIMESTAMP_FORMAT TIMESTAMP_FORMAT option [compatibility]
options: TIME_FORMAT TIME_FORMAT option [compatibility]
options: TIME_ZONE_ADJUSTMENT TIME_ZONE_ADJUSTMENT option [database]
options: transaction log [dblog] utility Transaction log utility options
options: TRUNCATE_DATE_VALUES TRUNCATE_DATE_VALUES option [database]
options: TRUNCATE_TIMESTAMP_VALUES TRUNCATE_TIMESTAMP_VALUES option [database]
options: TRUNCATE_WITH_AUTO_COMMIT TRUNCATE_WITH_AUTO_COMMIT option [database]
options: TRUNCATION_LENGTH TRUNCATION_LENGTH option [ISQL]
options: TSQL_HEX_CONSTANT TSQL_HEX_CONSTANT option [compatibility]
options: TSQL_VARIABLES TSQL_VARIABLES option [compatibility]
options: uncompression [dbexpand] utility Uncompression utility options
options: unload [dbunload] utility Unload utility options
options: UPDATE_STATISTICS UPDATE_STATISTICS option [database]
options: upgrade [dbupgrad] utility Upgrade utility options
options: USER_ESTIMATES USER_ESTIMATES option [database]
options: validation [dbvalid] utility Validation utility options
options: VERIFY_ALL_COLUMNS VERIFY_ALL_COLUMNS option [replication]
options: VERIFY_THRESHOLD VERIFY_THRESHOLD option [replication]
options: WAIT_FOR_COMMIT WAIT_FOR_COMMIT option [database]
options: write file [dbwrite] utility Write file utility options
OUTPUT_FORMAT option: description OUTPUT_FORMAT option [ISQL]
OUTPUT_FORMAT option: Interactive SQL settings Interactive SQL options
OUTPUT_LENGTH option: description OUTPUT_LENGTH option [ISQL]
OUTPUT_LENGTH option: Interactive SQL settings Interactive SQL options
OUTPUT_NULLS option: description OUTPUT_NULLS option [ISQL]
OUTPUT_NULLS option: Interactive SQL settings Interactive SQL options
OVERRIDE-MAGIC: USER_ESTIMATES option USER_ESTIMATES option [database]
owners: about Ownership permissions overview