Index

O

object_id Adaptive Server Enterprise function Connection properties
object_name Adaptive Server Enterprise function Connection properties
ODBC : connection parameters Connection parameters
ODBC : static cursors DECLARE CURSOR statement [ESQL] [SP]
ON_ERROR : Interactive SQL option ON_ERROR option [ISQL
ON_TSQL_ERROR : database option ON_TSQL_ERROR option
OPEN statement : QUERY_PLAN_ON_OPEN option QUERY_PLAN_ON_OPEN option
OPEN statement : syntax OPEN statement [ESQL] [SP]
opening cursors QUERY_PLAN_ON_OPEN option
operators : comparison operators Comparison conditions
operators : precedence of Operator precedence
optimization : defining existing tables and CREATE EXISTING TABLE statement
optimizer : estimates User-supplied estimates
options : about CHAPTER 5. Database Options
SET OPTION statement
options : ALLOW_NULLS_BY_DEFAULT Transact-SQLcompatibility options
ALLOW_NULLS_BY_DEFAULT option
options : ANSINULL ANSINULL option
options : ANSI_BLANKS Transact-SQLcompatibility options
ANSI_BLANKS option
options : ANSI_CLOSE_CURSORS_ON_ROLLBACK ANSI_CLOSE_CURSORS_ON_ROLLBACK option
options : ANSI_INTEGER_OVERFLOW ANSI_INTEGER_OVERFLOW option
options : ANSI_PERMISSIONS ANSI_PERMISSIONS option
options : AUDITING option AUDITING option
options : AUTOMATIC_TIMESTAMP Transact-SQLcompatibility options
AUTOMATIC_TIMESTAMP option
options : AUTO_REFETCH AUTO_REFETCH option [ISQL
options : BACKGROUND_PRIORITY General database options
BACKGROUND_PRIORITY option
options : BELL BELL option [ISQL
options : BLOCKING General database options
BLOCKING option
options : CHAINED CHAINED option
options : CHAR_OEM_TRANSLATION CHAR_OEM_TRANSLATION option [ISQL
options : CHECKPOINT_TIME General database options
CHECKPOINT_TIME option
options : CLOSE_ON_ENDTRANS CLOSE_ON_ENDTRANS option
options : COMMAND_DELIMITER COMMAND_DELIMITER option [ISQL
options : COMMIT_ON_EXIT COMMIT_ON_EXIT option [ISQL
options : compatibility Transact-SQLcompatibility options
options : CONTINUE_AFTER_RAISE_ERROR option CONTINUE_AFTER_RAISE_ERROR option
options : CONVERSION_ERROR Transact-SQLcompatibility options
CONVERSION_ERROR option
options : COOPERATIVE COMMITS COOPERATIVE_COMMITS option
options : COOPERATIVE_COMMITS General database options
options : COOPERATIVE_COMMIT_TIMEOUT General database options
COOPERATIVE_COMMIT_TIMEOUT option
options : cursors Duration of options
options : DATA_FORMAT DATE_FORMAT option
options : DATE_FORMAT General database options
options : DATE_ORDER General database options
DATE_ORDER option
options : DEFAULT_TIMESTAMP_INCREMENT General database options
DEFAULT_TIMESTAMP_INCREMENT option
options : DELAYED_COMMITS DELAYED_COMMITS option
options : DELAYED_COMMIT_TIMEOUT General database options
DELAYED_COMMIT_TIMEOUT option
options : DELETE_OLD_LOGS DELETE_OLD_LOGS option
options : DESCRIBE_JAVA_FORMAT DESCRIBE_JAVA_FORMAT option [ISQL]
options : DIVIDE_BY_ZERO_ERROR DIVIDE_BY_ZERO_ERROR option
options : duration Duration of options
options : ECHO ECHO option [ISQL
options : ESCAPE_CHARACTER ESCAPE_CHARACTER option
options : finding values Finding option settings
options : FIRE_TRIGGERS FIRE_TRIGGERS option
options : FLOAT_AS_DOUBLE FLOAT_AS_DOUBLE option
options : general General database options
options : GET OPTION statement GET OPTION statement [ESQL]
options : HEADINGS HEADINGS option [ISQL
options : in the system tables SYSOPTION system table
options : initial settings Initial option settings
sp_login_environment system procedure
sp_tsql_environment system procedure
options : INPUT_FORMAT INPUT_FORMAT option [ISQL
options : introduction Introduction to database options
options : ISOLATION_LEVEL General database options
ISOLATION_LEVEL option
options : ISQL_LOG ISQL_LOG option [ISQL
options : JAVA_HEAP_SIZE JAVA_HEAP_SIZE option
options : JAVA_NAMESPACE_SIZE JAVA_NAMESPACE_SIZE option
options : list General database options
options : LOGIN_MODE LOGIN_MODE option
options : LOGIN_PROCEDURE LOGIN_PROCEDURE option
options : MAX_CURSOR_COUNT MAX_CURSOR_COUNT option
options : MAX_STATEMENT_COUNT MAX_STATEMENT_COUNT option
options : MIN_PASSWORD_LENGTH option MIN_PASSWORD_LENGTH option
options : NEAREST_CENTURY option NEAREST_CENTURY option
options : NON_KEYWORDS NON_KEYWORDS option
options : ON_ERROR ON_ERROR option [ISQL
options : ON_TSQL_ERROR ON_TSQL_ERROR option
options : OUTPUT_FORMAT OUTPUT_FORMAT option [ISQL
options : OUTPUT_LENGTH OUTPUT_LENGTH option [ISQL
options : PERCENT_AS_COMMENT PERCENT_AS_COMMENT option
options : PRECISION General database options
PRECISION option
options : PREFETCH PREFETCH option
options : QUERY_PLAN_ON_OPEN Transact-SQLcompatibility options
QUERY_PLAN_ON_OPEN option
options : QUOTED_IDENTIFIER Transact-SQLcompatibility options
QUOTED_IDENTIFIER option
The quoted_identifier option
options : RECOVERY_TIME General database options
General database options
RECOVERY_TIME option
options : REPLICATE_ALL REPLICATE_ALL option
options : replication, list Replication options
options : REPLICATION_ERROR REPLICATION_ERROR option
options : RI_TRIGGER_TIME RI_Trigger_time option
options : ROW_COUNTS General database options
ROW_COUNTS option
options : SCALE General database options
SCALE option
options : scope The scope of database options
options : setting Setting options
Interactive SQL options
SET OPTION statement
SET OPTION statement [ISQL]
options : setting Interactive SQL options CONFIGURE statement [ISQL]
options : setting temporary Interactive SQL options
SET OPTION statement [ISQL]
options : SQL_FLAGGER_ERROR_LEVEL SQL_FLAGGER_ERROR_LEVEL option
options : SQL_FLAGGER_WARNING_LEVEL SQL_FLAGGER_WARNING_LEVEL option
options : STATISTICS STATISTICS option [ISQL
options : STRING_TRUNCATION STRING_RTRUNCATION option
options : SUBSCRIBE_BY_REMOTE SUBSCRIBE_BY_REMOTE option
options : system views SYSOPTIONS system view
SYSUSEROPTIONS system view
options : TEXTSIZE Transact-SQLcompatibility options
TEXTSIZE option
options : THREAD_COUNT General database options
THREAD_COUNT option
options : TIMESTAMP_FORMAT TIMESTAMP_FORMAT option
options : TIME_FORMAT General database options
TIME_FORMAT option
options : Transact-SQL SET statement [T-SQL]
options : Transact-SQL compatibility sp_tsql_environment system procedure
options : TRUNCATION_LENGTH TRUNCATION_LENGTH option [ISQL
options : TSQL_HEX_CONSTANT TSQL_HEX_CONSTANT option
options : TSQL_VARIABLES TSQL_VARIABLES option
options : VERIFY_ALL_COLUMNS VERIFY_ALL_COLUMNS option
options : VERIFY_THRESHOLD VERIFY_THRESHOLD option
options : WAIT_FOR_COMMIT General database options
WAIT_FOR_COMMIT option
OR keyword Conditions with logical operators
ORDER BY clause SELECT statement
outer joins : operators Join operators
output format : Interactive SQL option OUTPUT_FORMAT option [ISQL
output length : Interactive SQL option OUTPUT_LENGTH option [ISQL
OUTPUT statement : Java data OUTPUT statement [ISQL]
OUTPUT statement : syntax OUTPUT statement [ISQL]
owner Statement elements