Alphabetical List of Options

Descriptions of general, Transact-SQL compatibility, and Interactive SQL database options. Some option names are followed by a class indicator in square brackets.

• AFFINITY_AUTOEXCLUDE_TIMEOUT Option
  The amount of time before SAP Sybase IQ removes a shut down node from the affinity map and reassigns its partitions to other nodes.
• AGGREGATION_PREFERENCE Option
  Controls the choice of algorithms for processing an aggregate.
• ALLOW_NULLS_BY_DEFAULT Option [TSQL]
  Controls whether new columns created without specifying either NULL or NOT NULL are allowed to contain NULL values.
• ALLOW_SNAPSHOT_VERSIONING Option
  Applies to all base tables in the database (as opposed to RLV-enabled tables only). Restricts table versioning for all base tables to either table-level or row-level snapshot versioning. This option does not apply to the IQ catalog store.
• ANSI_CLOSE_CURSORS_ON_ROLLBACK Option [TSQL]
  Controls whether cursors that were opened WITH HOLD are closed when a ROLLBACK is performed.
• ANSI_PERMISSIONS Option [TSQL]
  Controls permissions checking for DELETE and UPDATE statements.
• ANSINULL Option [TSQL]
  Controls the interpretation of using = and != with NULL.
• ANSI_SUBSTRING Option [TSQL]
  Controls the behavior of the SUBSTRING (SUBSTR) function when negative values are provided for the start or length parameters.
• ANSI_UPDATE_CONSTRAINTS Option
  Controls the range of updates that are permitted.
• ALLOW_READ_CLIENT_FILE Option
  Enables client-side data transfer.
• ASE_BINARY_DISPLAY Option
  Specifies that the display of SAP Sybase IQ binary columns is consistent with the display of Adaptive Server binary columns.
• ASE_FUNCTION_BEHAVIOR Option
  Specifies that output of SAP Sybase IQ functions, including INTTOHEX and HEXTOINT, is consistent with the output of Adaptive Server functions.
• AUDITING Option [database]
  Enables and disables auditing in the database.
• BASE_TABLES_IN_RLV_STORE Option
  Registers newly created tables in the RLV store, enabling row-level versioning. RLV-enabled tables are eligible for multiple writer concurrent access. You can override this setting at the table level using the CREATE_TABLE statement.
• BIT_VECTOR_PINNABLE_CACHE_PERCENT Option
  Maximum percentage of a user’s temp memory that a persistent bit-vector object can pin.
• BLOCKING Option
  Controls the behavior in response to locking conflicts. BLOCKING is not supported on secondary nodes of a multiplex.
• BLOCKING_TIMEOUT Option
  Controls the length of time a transaction waits to obtain a lock. BLOCKING_TIMEOUT is not supported on secondary nodes of a multiplex.
• BT_PREFETCH_MAX_MISS Option
  Controls the way SAP Sybase IQ determines whether to continue prefetching B-tree pages for a given query.
• BT_PREFETCH_SIZE Option
  Restricts the size of the read-ahead buffer for the High_Group B-tree.
• BTREE_PAGE_SPLIT_PAD_PERCENT Option
  Determines per-page fill factor during page splits for B-Tree structures.
• CACHE_AFFINITY_PERCENT Option
  The maximum percentage of main buffer cache to use for affinity. Non-affinity data can use this area if insufficient affinity data exists.
• CACHE_PARTITIONS Option
  Sets the number of partitions to be used for the main and temporary buffer caches.
• CHAINED Option [TSQL]
  Controls transaction mode in the absence of a BEGIN TRANSACTION statement.
• CHECKPOINT_TIME Option
  Set the maximum length of time, in minutes, that the database server runs without doing a checkpoint.
• CIS_ROWSET_SIZE Option
  Sets the number of rows that are returned from remote servers for each fetch.
• CLOSE_ON_ENDTRANS Option [TSQL]
  Controls closing of cursors at the end of a transaction.
• CONTINUE_AFTER_RAISERROR Option [TSQL]
  Controls behavior following a RAISERROR statement.
• CONVERSION_ERROR Option [TSQL]
  Controls reporting of data type conversion failures on fetching information from the database.
• CONVERSION_MODE Option
  Restricts implicit conversion between binary data types (BINARY, VARBINARY, and LONG BINARY) and other non-binary data types (BIT, TINYINT, SMALLINT, INT, UNSIGNED INT, BIGINT, UNSIGNED BIGINT, CHAR, VARCHAR, and LONG VARCHAR) on various operations.
• CONVERT_VARCHAR_TO_1242 Option
  Converts pre-version 12.4.2 VARCHAR data to compressed format.
• COOPERATIVE_COMMIT_TIMEOUT Option
  Governs when a COMMIT entry in the transaction log is written to disk.
• COOPERATIVE_COMMITS Option
  Controls when commits are written to disk.
• CREATE_HG_WITH_EXACT_DISTINCTS
  Determines whether the database engine creates tiered HG or single-tiered HG indexes.
• CREATE_HG_AND_FORCE_PHYSICAL_DELETE
  Governs 16.0 tiered HG index delete behavior.
• CURSOR_WINDOW_ROWS Option
  Defines the number of cursor rows to buffer.
• DATE_FIRST_DAY_OF_WEEK Option
  Determines the first day of the week.
• DATE_FORMAT Option
  Sets the format used for dates retrieved from the database.
• DATE_ORDER Option
  Controls the interpretation of date formats.
• DBCC_LOG_PROGRESS Option
  Reports the progress of the sp_iqcheckdb system stored procedure.
• DBCC_PINNABLE_CACHE_PERCENT Option
  Controls the percent of the cache used by the sp_iqcheckdb system stored procedure.
• DEBUG_MESSAGES Option
  Controls whether or not MESSAGE statements that include a DEBUG ONLY clause are executed.
• DEDICATED_TASK Option
  Dedicates a request handling task to handling requests from a single connection.
• DEFAULT_DBSPACE Option
  Changes the default dbspace where tables are created.
• DEFAULT_DISK_STRIPING Option
  Sets the default disk striping value for all dbspaces.
• DEFAULT_HAVING_SELECTIVITY_PPM Option
  Provides default selectivity estimates to the optimizer for most HAVING clauses in parts per million.
• DEFAULT_ISQL_ENCODING Option [Interactive SQL]
  Specifies the code page used by READ and OUTPUT statements.
• DEFAULT_KB_PER_STRIPE Option
  Sets an upper threshold in KB on the amount to write to a stripe before write operations move on to the next stripe.
• DEFAULT_LIKE_MATCH_SELECTIVITY_PPM Option
  Provides default selectivity estimates (in parts per million) to the optimizer for most LIKE predicates.
• DEFAULT_LIKE_RANGE_SELECTIVITY_PPM Option
  Provides default selectivity estimates (in parts per million) to the optimizer for leading constant LIKE predicates.
• DEFAULT_PROXY_TABLE_ROW_COUNT Option
  Enables you to override the default estimate of the number of rows to return from a proxy table.
• DEFAULT_TABLE_UDF_ROW_COUNT Option
  Enables you to override the default estimate of the number of rows to return from a table UDF (either a C, C++, or Java table UDF).
• DELAYED_COMMIT_TIMEOUT Option
  Determines when the server returns control to an application following a COMMIT.
• DELAYED_COMMITS Option
  Determines when the server returns control to an application following a COMMIT.
• DISABLE_RI_CHECK Option
  Allows load, insert, update, or delete operations to bypass the referential integrity check, improving performance.
• DIVIDE_BY_ZERO_ERROR Option [TSQL]
  Controls the reporting of division by zero.
• DQP_ENABLED Option
  Temporary database option DQP_ENABLED allows you to enable or disable distributed query processing at the connection level.
• DQP_ENABLED_OVER_NETWORK Option
  Temporary database option DQP_ENABLED_OVER_NETWORK allows you to enable or disable distributed query processing over the network at the connection level.
• EARLY_PREDICATE_EXECUTION Option
  Controls whether simple local predicates are executed before query optimization.
• ENABLE_ASYNC_IO Option
  Allows a DBA to enable or disable the asynchronous IO used by the RLV persistence log.
• ENABLE_LOB_VARIABLES Option
  Controls the data type conversion of large object variables.
• EXTENDED_JOIN_SYNTAX Option
  Controls whether queries with an ambiguous syntax for multi-table joins are allowed or are reported as an error.
• FLOATING_POINT_ACCUMULATOR Option
  Controls which accumulator to use for SUM or AVG of floating-point numbers.
• FORCE_DROP Option
  Causes SAP Sybase IQ to leak, rather than reclaim, database disk space during a DROP command.
• FORCE_NO_SCROLL_CURSORS Option
  Forces all cursors to be non-scrolling.
• FORCE_UPDATABLE_CURSORS Option
  Controls whether cursors that have not been declared as updatable can be updated.
• FP_LOOKUP_SIZE Option
  Specifies the number of lookup pages and cache memory allocated for Lookup FP indexes in SAP Sybase IQ 15. databases.
• FP_LOOKUP_SIZE_PPM Option
  Controls the amount of main buffer cache allocated to FP indexes in SAP Sybase IQ 15 databases.
• FP_NBIT_AUTOSIZE_LIMIT Option
  Limits the number of distinct values in columns that implicitly load as NBit FP.
• FP_NBIT_ENFORCE_LIMITS Option
  Enforces sizing limits for explicit and implicit NBit columns.
• FP_NBIT_IQ15_COMPATIBILITY Option
  Provides support for tokenized FP indexes similar to that available in SAP Sybase IQ 15.
• FP_NBIT_LOOKUP_MB Option
  Limits the total dictionary size for implicit NBit FP columns.
• FP_NBIT_ROLLOVER_MAX_MB Option
  Sets a threshold for the total dictionary size for implicit NBit rollovers to Flat FP.
• FP_PREDICATE_WORKUNIT_PAGES Option
  Specifies degree of parallelism used in the default index.
• FPL_EXPRESSION_MEMORY_KB Option
  Controls the use of memory for the optimization of queries involving functional expressions against columns having enumerated storage.
• GARRAY_FILL_FACTOR_PERCENT Option
  Specifies the percent of space on each HG garray page to reserve for future incremental inserts into existing groups.
• GARRAY_INSERT_PREFETCH_SIZE Option
  Specifies number of pages used for prefetch.
• GARRAY_PAGE_SPLIT_PAD_PERCENT Option
  Determines per-page fill factor during page splits on the garray and specifies the percent of space on each HG garray page to reserve for future incremental inserts.
• GARRAY_RO_PREFETCH_SIZE Option
  Specifies number of pages used for prefetch.
• HASH_PINNABLE_CACHE_PERCENT Option
  Controls the maximum percentage of a user’s temp memory that a hash object can pin.
• HASH_THRASHING_PERCENT Option
  Specifies the percent of hard disk I/Os allowed during the execution of a statement that includes a query involving hash algorithms, before the statement is rolled back and an error message is reported.
• HG_DELETE_METHOD Option
  Specifies the algorithm used during a delete in a HG index.
• HG_SEARCH_RANGE Option
  Specifies the maximum number of Btree pages used in evaluating a range predicate in the HG index.
• HTTP_SESSION_TIMEOUT Option
  Specifies the amount of time, in minutes, that the client waits for an HTTP session to time out before giving up.
• IDENTITY_ENFORCE_UNIQUENESS Option
  Creates a unique HG index on each IDENTITY/AUTOINCREMENT column, if the column is not already a primary key.
• IDENTITY_INSERT Option
  Enables users to insert values into or to update an IDENTITY or AUTOINCREMENT column.
• IN_SUBQUERY_PREFERENCE Option
  Controls the choice of algorithms for processing an IN subquery.
• INDEX_ADVISOR Option
  Generates messages suggesting additional column indexes that may improve performance of one or more queries.
• INDEX_ADVISOR_MAX_ROWS Option
  Sets the maximum number of unique advice messages stored by the index advisor to max_rows.
• INDEX_PREFERENCE Option
  Controls the choice of indexes to use for queries.
• INFER_SUBQUERY_PREDICATES Option
  Controls the optimizer’s inference of additional subquery predicates.
• IQGOVERN_MAX_PRIORITY Option
  Limits the allowed IQGOVERN_PRIORITY setting.
• IQGOVERN_PRIORITY Option
  Assigns a priority to each query waiting in the -iqgovern queue.
• IQGOVERN_PRIORITY_TIME Option
  Limits the time a high priority query waits in the queue before starting.
• ISOLATION_LEVEL Option
  Controls the locking isolation level for catalog store tables.
• JAVA_LOCATION Option
  Specifies the path of the Java VM for the database.
• JAVA_VM_OPTIONS Option
  Specifies command line options that the database server uses when it launches the Java VM.
• JOIN_EXPANSION_FACTOR Option
  Controls how conservative the optimizer’s join result estimates are in unusually complex situations.
• JOIN_OPTIMIZATION Option
  Enables or disables the optimization of the join order.
• JOIN_PREFERENCE Option
  Controls the choice of algorithms when processing joins.
• JOIN_SIMPLIFICATION_THRESHOLD Option
  Controls the minimum number of tables being joined together before any join optimizer simplifications are applied.
• LF_BITMAP_CACHE_KB Option
  Specifies the amount of memory to use for a load into a LF index.
• LOAD_ZEROLENGTH_ASNULL Option
  Specifies LOAD statement behavior under certain conditions.
• LOG_CONNECT Option
  Controls logging of user connections.
• LOG_CURSOR_OPERATIONS Option
  Controls logging of cursor operations.
• LOG_DEADLOCKS Option
  Controls whether deadlock reporting is turned on or off.
• LOGIN_MODE Option
  Controls the use of integrated logins for the database.
• LOGIN_PROCEDURE Option
  Specifies a login procedure that sets connection compatibility options at start-up.
• MAIN_RESERVED_DBSPACE_MB Option
  Controls the amount of space SAP Sybase IQ reserves in the IQ main store.
• MAX_CARTESIAN_RESULT Option
  Limits the number of rows resulting from a Cartesian join.
• MAX_CLIENT_NUMERIC_PRECISION Option
  Controls the maximum precision for numeric data sent to the client.
• MAX_CLIENT_NUMERIC_SCALE Option
  Controls the maximum scale for numeric data sent to the client.
• MAX_CUBE_RESULT Option
  Sets the maximum number of rows that the IQ optimizer considers for a GROUP BY CUBE operation.
• MAX_CURSOR_COUNT Option
  Specifies a resource governor to limit the maximum number of cursors that a connection can use at once.
• MAX_HASH_ROWS Option
  Sets the maximum number of rows that the IQ optimizer considers for a hash algorithm.
• MAX_IQ_THREADS_PER_CONNECTION Option
  Controls the number of threads for each connection.
• MAX_IQ_THREADS_PER_TEAM Option
  Controls the number of threads allocated to perform a single operation (such as a LIKE predicate on a column) executing within a connection.
• MAX_JOIN_ENUMERATION Option
  Controls the maximum number of tables to be optimized for join order after optimizer simplifications have been applied.
• MAX_PARTITIONED_HASH_MB Option
  Sets an upper bound, expressed in megabytes, on the amount of temporary cache space that the optimizer can assume will be available for hash-partitioned hash-based query operators.
• MAX_PREFIX_PER_CONTAINS_PHRASE Option
  Specifies the number of prefix terms allowed in a text search expression.
• MAX_QUERY_PARALLELISM Option
  Sets upper bound for parallel execution of GROUP BY operations and for arms of a UNION.
• MAX_QUERY_TIME Option
  Sets a time limit so that the optimizer can disallow very long queries.
• MAX_STATEMENT_COUNT Option
  Specifies a resource governor to limit the maximum number of prepared statements that a connection can use at once.
• MAX_TEMP_SPACE_PER_CONNECTION Option
  Limits temporary store space used per connection.
• MINIMIZE_STORAGE Option
  Minimizes use of disk space for newly created columns in SAP Sybase IQ 15 databases.
• MIN_PASSWORD_LENGTH Option
  Sets the minimum length for new passwords in the database.
• MIN_ROLE_ADMINS Option
  Configures of the minimum number of required administrators for all roles.
• MONITOR_OUTPUT_DIRECTORY Option
  Controls placement of output files for the IQ buffer cache monitor.
• MPX_AUTOEXCLUDE_TIMEOUT Option
  Timeout for autoexcluding a secondary node on the coordinator node. This option does not apply to the designated failover node.
• MPX_HEARTBEAT_FREQUENCY Option
  Interval until the heartbeat thread wakes and performs periodic operations, such as checking for coordinator connectivity and cleaning up the connection pool on the secondary node. The heartbeat thread maintains a dedicated internal connection from secondary server to coordinator.
• MPX_IDLE_CONNECTION_TIMEOUT Option
  Time after which an unused connection in the connection pool on a secondary node will be closed.
• MPX_LIVENESS_TIMEOUT Option
  Time, in seconds, before a heartbeat on a secondary server declares the coordinator offline if the heartbeat fails to reconnect to the coordinator after the first disconnect. This option also determines how long the coordinator keeps a global transaction in a suspended state.
• MPX_MAX_CONNECTION_POOL_SIZE Option
  Maximum number of connections allowed in the connection pool on a secondary node.
• MPX_MAX_UNUSED_POOL_SIZE Option
  Maximum number of unused connections in the connection pool on a secondary node.
• MPX_WORK_UNIT_TIMEOUT Option
  Time, in seconds, before a multiplex DQP leader reassigns incomplete distributed work to another DQP worker node.
• NEAREST_CENTURY Option [TSQL]
  Controls the interpretation of 2-digit years, in string to date conversions.
• NOEXEC Option
  Generates the optimizer query plans instead of executing the plan.
• NON_ANSI_NULL_VARCHAR Option
  Controls whether zero-length VARCHAR data is treated as NULLs for insert, load, and update operations.
• NON_KEYWORDS Option [TSQL]
  Turns off individual keywords, allowing their use as identifiers.
• NOTIFY_MODULUS Option
  Controls the default frequency of notify messages issued by certain commands.
• ODBC_DISTINGUISH_CHAR_AND_VARCHAR Option
  Controls how the SAP Sybase IQ ODBC driver describes CHAR columns.
• ON_CHARSET_CONVERSION_FAILURE Option
  Controls the action taken, if an error is encountered during character conversion.
• ON_ERROR Option [Interactive SQL]
  Controls the action taken if an error is encountered while executing statements in Interactive SQL.
• ON_TSQL_ERROR Option [TSQL]
  Controls error handling in stored procedures.
• OS_FILE_CACHE_BUFFERING Option
  Controls use of file system buffering for IQ Main dbspaces.
• OS_FILE_CACHE_BUFFERING_TEMPDB Option
  Controls the use of file system buffering for IQ Temporary dbspaces.
• POST_LOGIN_PROCEDURE Option
  Specifies a login procedure whose result set contains messages that are displayed by the client application immediately after a user successfully logs in.
• PRECISION Option
  Specifies the maximum number of digits in the result of any decimal arithmetic, for queries on the catalog store only.
• PREFETCH Option
  Allows you to turn fetching on or off or to use the ALWAYS value to prefetch the cursor results, even for SENSITIVE cursor types and for cursors that involve a proxy table.
• PREFETCH_BUFFER_LIMIT Option
  Specifies the amount of memory used for prefetching.
• PREFETCH_BUFFER_PERCENT Option
  Specifies the percent of memory used for prefetching.
• PREFETCH_GARRAY_PERCENT Option
  Specifies the percent of prefetch resources designated for inserts to HG indexes.
• PREFETCH_SORT_PERCENT Option
  Specifies the percent of prefetch resources designated for sorting objects.
• PRESERVE_SOURCE_FORMAT Option [database]
  Controls whether the original source definition of procedures, views, and event handlers is saved in system files. If saved, the formatted source is saved in the column source in SYSTABLE, SYSPROCEDURE, and SYSEVENT.
• QUERY_DETAIL Option
  Specifies whether or not to include additional query information in the Query Detail section of the query plan.
• QUERY_NAME Option
  Gives a name to an executed query in its query plan.
• QUERY_PLAN Option
  Specifies whether or not additional query plans are printed to the SAP Sybase IQ message file.
• QUERY_PLAN_AFTER_RUN Option
  Prints the entire query plan after query execution is complete.
• QUERY_PLAN_AS_HTML Option
  Generates graphical query plans in HTML format for viewing in a Web browser.
• QUERY_PLAN_AS_HTML_DIRECTORY Option
  Specifies the directory into which SAP Sybase IQ writes the HTML query plans.
• QUERY_PLAN_MIN_TIME Option
  Specifies a threshold for query execution. The post-query plan is generated only if query execution time exceeds the threshold.
• QUERY_PLAN_TEXT_ACCESS Option
  Enables or prevents users from accessing query plans from the Interactive SQL client or from using SQL functions to get plans.
• QUERY_PLAN_TEXT_CACHING Option
  Allows you to specify whether or not SAP Sybase IQ generates and caches IQ plans for queries executed by the user.
• QUERY_ROWS_RETURNED_LIMIT Option
  Sets the row threshold for rejecting queries based on estimated size of result set.
• QUERY_TEMP_SPACE_LIMIT Option
  Specifies the maximum estimated amount of temp space before a query is rejected.
• QUERY_TIMING Option
  Determines whether or not to collect specific timing statistics and display them in the query plan.
• QUOTED_IDENTIFIER Option [TSQL]
  Controls the interpretation of strings that are enclosed in double quotes.
• RECOVERY_TIME Option
  Sets the maximum length of time, in minutes, that the database server takes to recover from system failure.
• RESERVED_KEYWORDS Option
  Turns on individual keywords that are disabled by default.
• RETURN_DATE_TIME_AS_STRING Option
  Controls how a date, time, or timestamp value is passed to the client application when queried.
• REVERT_TO_V15_OPTIMIZER Option
  Setting this option ON forces the query optimizer to mimic SAP Sybase IQ  15.x behavior.
• ROUND_TO_EVEN Option
  Controls behavior of the SQL function ROUND.
• ROW_COUNT Option
  Limits the number of rows returned from a query.
• RV_AUTO_MERGE_EVAL_INTERVAL Option
  This option configures the evaluation period used to determine when an automated merge of the row-level versioned (RLV) and IQ main stores should occur.
• RV_MAX_ACTIVE_SUBFRAGMENT_COUNT Option
  This value maximizes utilization of the number of cores on the machine.
• RV_MERGE_NODE_MEMSIZE Option
  An automated merge of the row-level versioned (RLV) store and IQ main stores occurs based on the merge thresholds, including RV_MERGE_NODE_MEMSIZE. When this node threshold is exceeded, a merge will be triggered.
• RV_MERGE_TABLE_MEMPERCENT Option
  An automated merge of the row-level versioned (RLV) store and IQ main stores occurs based on the merge thresholds, including RV_MERGE_TABLE_MEMPERCENT. If this table threshold is exceeded, a merge will be triggered for the specific table.
• RV_MERGE_TABLE_NUMROWS Option
  An automated merge of the row-level versioned (RLV) store and IQ main stores occurs based on the merge thresholds, including RV_MERGE_TABLE_NUMROWS. If this table threshold is exceeded, a merge will be triggered for the specific table.
• RV_RESERVED_DBSPACE_MB Option
  A portion of the RLV store must be reserved for memory used by data structures during critical operations.
• SCALE Option
  Specifies the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum PRECISION, for queries on the catalog store only.
• SNAPSHOT_VERSIONING Option
  Applies to RLV-enabled tables only (as opposed to all base tables in the database). Controls whether RLV-enabled tables are accessed using single-writer table-level versioning, or multiple writer row-level versioning. This option does not apply to the IQ catalog store.
• SIGNIFICANTDIGITSFORDOUBLEEQUALITY Option
  Specifies the number of significant digits to the right of the decimal in exponential notation that are used in equality tests between two complex arithmetic expressions.
• SORT_COLLATION Option
  Allows implicit use of the SORTKEY function on ORDER BY expressions.
• SORT_PINNABLE_CACHE_PERCENT Option
  Specifies the maximum percentage of currently available buffers a sort object tries to pin.
• SQL_FLAGGER_ERROR_LEVEL Option [TSQL]
  Controls the behavior in response to any SQL code that is not part of the specified standard.
• SQL_FLAGGER_WARNING_LEVEL Option [TSQL]
  Controls the response to any SQL that is not part of the specified standard.
• STRING_RTRUNCATION Option [TSQL]
  Determines whether an error is raised when an INSERT or UPDATE truncates a CHAR or VARCHAR string.
• SUBQUERY_CACHING_PREFERENCE Option
  Controls which algorithm to use for processing correlated subquery predicates.
• SUBQUERY_FLATTENING_PERCENT Option
  Allows the user to change the threshold at which the optimizer decides to transform scalar subqueries into joins.
• SUBQUERY_FLATTENING_PREFERENCE Option
  Allows a user to override the decisions of the optimizer when transforming (flattening) scalar or EXISTS subqueries into joins.
• SUBQUERY_PLACEMENT_PREFERENCE Option
  Controls the placement of correlated subquery predicate operators within a query plan.
• SUPPRESS_TDS_DEBUGGING Option
  Determines whether TDS debugging information appears in the server window.
• SWEEPER_THREADS_PERCENT Option
  Specifies the percentage of SAP Sybase IQ threads used to sweep out buffer caches.
• TDS_EMPTY_STRING_IS_NULL Option [database]
  Controls whether empty strings are returned as NULL or a string containing one blank character for TDS connections.
• TEMP_EXTRACT_APPEND Option
  Specifies that any rows extracted by the data extraction facility are added to the end of an output file.
• TEMP_EXTRACT_BINARY Option
  In combination with the TEMP_EXTRACT_SWAP option, specifies the type of extraction performed by the data extraction facility.
• TEMP_EXTRACT_COLUMN_DELIMITER Option
  Specifies the delimiter between columns in the output of the data extraction facility for an ASCII extraction.
• TEMP_EXTRACT_DIRECTORY Option
  Controls whether a user is allowed to use the data extraction facility. Also controls the directory into which temp extract files are placed and overrides a directory path specified in the TEMP_EXTRACT_NAMEn options.
• TEMP_EXTRACT_ESCAPE_QUOTES Option
  Specifies whether all quotes in fields containing quotes are escaped in the output of the data extraction facility for an ASCII extraction.
• TEMP_EXTRACT_NAMEn Options
  Specifies the names of the output files or named pipes used by the data extraction facility. There are eight options: TEMP_EXTRACT_NAME1 through TEMP_EXTRACT_NAME8.
• TEMP_EXTRACT_NULL_AS_EMPTY Option
  Controls the representation of null values in the output of the data extraction facility for an ASCII extraction.
• TEMP_EXTRACT_NULL_AS_ZERO Option
  Controls the representation of null values in the output of the data extraction facility for an ASCII extraction.
• TEMP_EXTRACT_QUOTE Option
  Specifies the string to be used as the quote to enclose fields in the output of the data extraction facility for an ASCII extraction, when either the TEMP_EXTRACT_QUOTES option or the TEMP_EXTRACT_QUOTES_ALL option is set ON.
• TEMP_EXTRACT_QUOTES Option
  Specifies that string fields are enclosed in quotes in the output of the data extraction facility for an ASCII extraction.
• TEMP_EXTRACT_QUOTES_ALL Option
  Specifies that all fields are enclosed in quotes in the output of the data extraction facility for an ASCII extraction.
• TEMP_EXTRACT_ROW_DELIMITER Option
  Specifies the delimiter between rows in the output of the data extraction facility for an ASCII extraction.
• TEMP_EXTRACT_SIZEn Options
  Specifies the maximum sizes of the corresponding output files used by the data extraction facility.
• TEMP_EXTRACT_SWAP Option
  In combination with the TEMP_EXTRACT_BINARY option, specifies the type of extraction performed by the data extraction facility.
• TEMP_RESERVED_DBSPACE_MB Option
  Controls the amount of space SAP Sybase IQ reserves in the temporary IQ store.
• TEMP_SPACE_LIMIT_CHECK Option
  Checks for catalog store temporary space on a per connection basis.
• TEXT_DELETE_METHOD Option
  Specifies the algorithm used during a delete in a TEXT index.
• TIME_FORMAT Option
  Sets the format used for times retrieved from the database.
• TIMESTAMP_FORMAT Option
  Sets the format used for timestamps retrieved from the database.
• TOP_NSORT_CUTOFF_PAGES Option
  Sets the result size threshold for TOP N algorithm selection.
• TRIM_PARTIAL_MBC Option
  Allows automatic trimming of partial multibyte character data.
• TRUSTED_CERTIFICATES_FILE Option
  Specifies the trust relationship for outbound Transport Layer Security (TLS) connections made by LDAP User Authentication, INC, and MIPC connections.
• TSQL_VARIABLES Option [TSQL]
  Controls whether the @ sign can be used as a prefix for Embedded SQL host variable names.
• USER_RESOURCE_RESERVATION Option
  Adjusts memory use for the number of current users.
• VERIFY_PASSWORD_FUNCTION Option
  Specifies a user-supplied authentication function that can be used to implement password rules.
• WASH_AREA_BUFFERS_PERCENT Option
  Specifies the percentage of the buffer caches above the wash marker.
• WAIT_FOR_COMMIT Option
  Determines when foreign key integrity is checked as data is manipulated.
• WD_DELETE_METHOD Option
  Specifies the algorithm used during a delete in a WD index.