ASA Database Administration Guide
  Database Options

Alphabetical list of options

This section lists options alphabetically.

ALLOW_NULLS_BY_DEFAULT option [compatibility]
ANSI_BLANKS option [compatibility]
ANSI_CLOSE_CURSORS_ON_ROLLBACK option [compatibility]
ANSI_INTEGER_OVERFLOW option [compatibility]
ANSI_PERMISSIONS option [compatibility]
ANSI_UPDATE_CONSTRAINTS option [compatibility]
ANSINULL option [compatibility]
AUDITING option [database]
AUTO_COMMIT option [ISQL]
AUTO_REFETCH option [ISQL]
AUTOMATIC_TIMESTAMP option [compatibility]
BACKGROUND_PRIORITY option [database]
BELL option [ISQL]
BLOB_THRESHOLD option [replication]
BLOCKING option [database]
BLOCKING_TIMEOUT option [database]
CHAINED option [compatibility]
CHECKPOINT_TIME option [database]
CIS_OPTION option [database]
CIS_ROWSET_SIZE option [database]
CLOSE_ON_ENDTRANS option [compatibility]
COMMAND_DELIMITER option [ISQL]
COMMIT_ON_EXIT option [ISQL]
COMPRESSION option [replication]
CONTINUE_AFTER_RAISERROR option [compatibility]
CONVERSION_ERROR option [compatibility]
COOPERATIVE_COMMIT_TIMEOUT option [database]
COOPERATIVE_COMMITS option [database]
DATE_FORMAT option [compatibility]
DATE_ORDER option [compatibility]
DEFAULT_TIMESTAMP_INCREMENT option [database]
DELAYED_COMMIT_TIMEOUT option [database]
DELAYED_COMMITS option [database]
DELETE_OLD_LOGS option [replication]
DESCRIBE_JAVA_FORMAT option [ISQL]
DIVIDE_BY_ZERO_ERROR option [compatibility]
ECHO option [ISQL]
ESCAPE_CHARACTER option [compatibility]
EXCLUDE_OPERATORS option [database]
EXTENDED_JOIN_SYNTAX option [database]
FIRE_TRIGGERS option [compatibility]
FIRST_DAY_OF_WEEK option [database]
FLOAT_AS_DOUBLE option [compatibility]
FOR_XML_NULL_TREATMENT option [database]
GLOBAL_DATABASE_ID option [database]
INPUT_FORMAT option [ISQL]
ISOLATION_LEVEL option [compatibility]
ISQL_COMMAND_TIMING option [ISQL]
ISQL_ESCAPE_CHARACTER option [ISQL]
ISQL_FIELD_SEPARATOR option [ISQL]
ISQL_LOG option [ISQL]
ISQL_PLAN option [ISQL]
ISQL_PRINT_RESULT_SET option [ISQL]
ISQL_QUOTE option [ISQL]
JAVA_HEAP_SIZE option [database]
JAVA_INPUT_OUTPUT option [database]
JAVA_NAMESPACE_SIZE option [database]
LOGIN_MODE option [database]
LOGIN_PROCEDURE option [database]
MAX_CURSOR_COUNT option [database]
MAX_HASH_SIZE option [database]
MAX_PLANS_CACHED option [database]
MAX_RECURSIVE_ITERATIONS [database]
MAX_WORK_TABLE_HASH_SIZE option [database]
MAX_STATEMENT_COUNT option [database]
MIN_PASSWORD_LENGTH option [database]
MIN_TABLE_SIZE_FOR_HISTOGRAM option [database]
NEAREST_CENTURY option [compatibility]
NON_KEYWORDS option [compatibility]
NULLS option [ISQL]
ON_CHARSET_CONVERSION_FAILURE option [database]
ON_ERROR option [ISQL]
ON_TSQL_ERROR option [compatibility]
OPTIMISTIC_WAIT_FOR_COMMIT
OPTIMIZATION_GOAL option [database]
OUTPUT_FORMAT option [ISQL]
OUTPUT_LENGTH option [ISQL]
OUTPUT_NULLS option [ISQL]
PERCENT_AS_COMMENT option [compatibility]
PINNED_CURSOR_PERCENT_OF_CACHE option [database]
PRECISION option [database]
PREFETCH option [database]
PRESERVE_SOURCE_FORMAT option [database]
PREVENT_ARTICLE_PKEY_UPDATE option [database]
QUALIFY_OWNERS option [replication]
QUERY_PLAN_ON_OPEN option [compatibility]
QUOTE_ALL_IDENTIFIERS option [replication]
QUOTED_IDENTIFIER option [compatibility]
READ_PAST_DELETED option [database]
RECOVERY_TIME option [database]
REPLICATE_ALL option [replication]
REPLICATION_ERROR option [replication]
REPLICATION_ERROR_PIECE option [replication]
RETURN_DATE_TIME_AS_STRING option [database]
RETURN_JAVA_AS_STRING option [database]
RI_TRIGGER_TIME option [compatibility]
ROW_COUNTS option [database]
SCALE option [database]
SORT_COLLATION option [database]
SQL_FLAGGER_ERROR_LEVEL option [compatibility]
SQL_FLAGGER_WARNING_LEVEL option [compatibility]
STATISTICS option [ISQL]
STRING_RTRUNCATION option [compatibility]
SUBSCRIBE_BY_REMOTE option [replication]
SUBSUME_ROW_LOCKS option [database]
SUPPRESS_TDS_DEBUGGING option [database]
TDS_EMPTY_STRING_IS_NULL option [database]
TIME_FORMAT option [compatibility]
TIME_ZONE_ADJUSTMENT option [database]
TIMESTAMP_FORMAT option [compatibility]
TRUNCATE_DATE_VALUES option [database]
TRUNCATE_TIMESTAMP_VALUES option [database]
TRUNCATE_WITH_AUTO_COMMIT option [database]
TRUNCATION_LENGTH option [ISQL]
TSQL_HEX_CONSTANT option [compatibility]
TSQL_VARIABLES option [compatibility]
UPDATE_STATISTICS option [database]
USER_ESTIMATES option [database]
VERIFY_ALL_COLUMNS option [replication]
VERIFY_THRESHOLD option [replication]
WAIT_FOR_COMMIT option [database]