ASA Database Administration Guide
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 [Interactive SQL]
AUTO_REFETCH option [Interactive SQL]
AUTOMATIC_TIMESTAMP option [compatibility]
BACKGROUND_PRIORITY option [database]
BELL option [Interactive SQL]
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 [Interactive SQL]
COMMIT_ON_EXIT option [Interactive SQL]
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]
DEBUG_MESSAGES option [database]
DEDICATED_TASK option [database]
DEFAULT_ISQL_ENCODING option [Interactive SQL]
DEFAULT_TIMESTAMP_INCREMENT option [database]
DELAYED_COMMIT_TIMEOUT option [database]
DELAYED_COMMITS option [database]
DELETE_OLD_LOGS option [replication]
DESCRIBE_JAVA_FORMAT option [Interactive SQL]
DIVIDE_BY_ZERO_ERROR option [compatibility]
ECHO option [Interactive SQL]
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]
FORCE_VIEW_CREATION option [database]
GLOBAL_DATABASE_ID option [database]
INPUT_FORMAT option [Interactive SQL]
INTEGRATED_SERVER_NAME option [database]
ISOLATION_LEVEL option [compatibility]
ISQL_COMMAND_TIMING option [Interactive SQL]
ISQL_ESCAPE_CHARACTER option [Interactive SQL]
ISQL_FIELD_SEPARATOR option [Interactive SQL]
ISQL_LOG option [Interactive SQL]
ISQL_PLAN option [Interactive SQL]
ISQL_PRINT_RESULT_SET option [Interactive SQL]
ISQL_QUOTE option [Interactive SQL]
JAVA_HEAP_SIZE option [database]
JAVA_INPUT_OUTPUT option [database]
JAVA_NAMESPACE_SIZE option [database]
LOG_DEADLOCKS option [database]
LOGIN_MODE option [database]
LOGIN_PROCEDURE option [database]
MAX_CURSOR_COUNT option [database]
MAX_HASH_SIZE option [database] (deprecated)
MAX_PLANS_CACHED option [database]
MAX_RECURSIVE_ITERATIONS option [database]
MAX_STATEMENT_COUNT option [database]
MAX_WORK_TABLE_HASH_SIZE option [database] (deprecated)
MIN_PASSWORD_LENGTH option [database]
NEAREST_CENTURY option [compatibility]
NON_KEYWORDS option [compatibility]
NULLS option [Interactive SQL]
ODBC_DESCRIBE_BINARY_AS_VARBINARY [database]
ODBC_DISTINGUISH_CHAR_AND_VARCHAR option [database]
ON_CHARSET_CONVERSION_FAILURE option [database]
ON_ERROR option [Interactive SQL]
ON_TSQL_ERROR option [compatibility]
OPTIMISTIC_WAIT_FOR_COMMIT option [compatibility]
OPTIMIZATION_GOAL option [database]
OPTIMIZATION_LEVEL option [database]
OPTIMIZATION_WORKLOAD option [database]
OUTPUT_FORMAT option [Interactive SQL]
OUTPUT_LENGTH option [Interactive SQL]
OUTPUT_NULLS option [Interactive SQL]
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]
REMOTE_IDLE_TIMEOUT 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]
ROLLBACK_ON_DEADLOCK [database]
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 [Interactive SQL]
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]
TEMP_SPACE_LIMIT_CHECK option [database]
TIME_FORMAT option [compatibility]
TIME_ZONE_ADJUSTMENT option [database]
TIMESTAMP_FORMAT option [compatibility]
TRUNCATE_DATE_VALUES option [database] (deprecated)
TRUNCATE_TIMESTAMP_VALUES option [database]
TRUNCATE_WITH_AUTO_COMMIT option [database]
TRUNCATION_LENGTH option [Interactive SQL]
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]
WEBSERVICE_NAMESPACE_HOST option [database]
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.