Setting ASE Connection Level Option Preferences

Specify default values for the launch configuration of newly created Adaptive Server Enterprise procedural objects and the SQL Editor. Set these preferences in Window|Preferences|Connection Level Options, on the tab for your version:

Adaptive Server Enterprise_12.5.x
Adaptive Server Enterprise_15.x

Specify behavior for execution plans in the Query Analysis frame.

Connection Level Options: Query Analysis

Field	Explanation
Force plan	Click to process a join in the same order as tables appear in the FROM clause of a SELECT statement only. Default is OFF.
No exec	Click to compile and return the query plan, but not execute the query. Default is OFF.
Parse only	Click to check the syntax of each Transact-SQL statement and return any error messages without compiling or executing the statement. Unlike No Exec, with Parse only a statement without syntax errors can produce errors in compiling or execution time. Default is OFF.
Statistics IO	Click to display information on the amount of disk activity generated by Transact-SQL statements. Default is OFF.
Statistics time	Click to display the number of milliseconds needed to parse, compile, and execute each statement. Default is OFF.
Statistics subquery cache	Click to display the number of cache hits, misses, and number of rows in the subquery cache for each subquery. Default is OFF.

Specify behavior for arithmetic overflow or truncation in the Arithmetic frame.

Connection Level Options: Arithmetic

Field	Explanation
Ignore arithmetic overflow	Click to print an error message if arithmetic overflow or numeric truncation occurs. Default is OFF.
Abort on arithmetic overflow	When this option is checked, ASE aborts the current query or procedure when arithmetic overflow occurs. Default is ON.
Abort on arithmetic truncation	When this option is checked, ASE aborts the current query or procedure when arithmetic truncation occurs. Default is ON.

Specify behavior for transactions in the Transactions frame.

Connection Level Options: Transactions

Field Explanation

Field	Explanation
Chained	Set the autocommit option: Select this check box to start a new transaction after every `insert`, `update`, or `delete`. Deselect to autocommit every `insert`, `update`, and `delete`. Default.
Isolation Level	Select locking behavior: 0 — Allow dirty reads, nonrepeatable reads, and phantom rows. 1 — Prevent dirty reads, allow nonrepeatable reads, and phantom rows. Default for JDBC connections. 2 — Prevent dirty reads and guarantee repeatable reads, allow phantom rows. 3 — Serializable: Do not allow dirty reads, guarantee repeatable reads, and do not allow phantom rows.

Chained

Set the autocommit option:

Select this check box to start a new transaction after every insert, update, or delete.
Deselect to autocommit every insert, update, and delete. Default.

Isolation Level

Select locking behavior:

0 — Allow dirty reads, nonrepeatable reads, and phantom rows.
1 — Prevent dirty reads, allow nonrepeatable reads, and phantom rows. Default for JDBC connections.
2 — Prevent dirty reads and guarantee repeatable reads, allow phantom rows.
3 — Serializable: Do not allow dirty reads, guarantee repeatable reads, and do not allow phantom rows.

Specify behavior for the DBCC utility in the DBCC traceflags frame.

Connection Level Options: DBCC traceflags

Field	Explanation
Index selection (302)	Click to print index selection information in DBCC output. Default is OFF.
Join selection (310)	Click to print join selection information in DBCC output. Default is OFF.
Output to SQL Results View	Click to include DBCC information in the SQL Results view. Default is OFF. Only available when Index selection or Join selection is checked.
Output to server log	Click to include DBCC information in the server error log. Default is OFF. Only available when Index selection or Join selection is checked.

Specify behavior for NULLs and strings in the Miscellaneous frame.

Connection Level Options: Miscellaneous

Field	Explanation
ANSI NULL	When the check box is selected, any comparisons with NULL using = or != evaluate to unknown. Default is ON.
Quoted identifier	When the check box is selected, strings enclosed in double quotes are interpreted as identifiers. Default is OFF for JDBC connections.

Setting Connection-Level Option Preferences

Preferences

See Performance and Tuning: Locking; Monitoring and Analyzing; Optimizer and Abstract Plans in the Adaptive Server Enterprise collection under Sybase WorkSpace Server Administration .