Setting ASA Connection Level Option Preferences

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

Note

Connection Level options are server settings.

Connection Level Options: Arithmetic

Field	Explanation
Ansi integer overflow	Click for integer overflow errors to cause a SQLSTATE = 22003 - overflow error (SQL/92 behavior). Default is OFF.
Divide by zero	Click for division by zero to report an error with SQLSTATE 22012. Do not click to return NULL. Default is ON.

Connection Level Options: On TSQL Error

Field	Explanation
On TSQL Error	Select error handling action for stored procedures: Stop — Stop execution immediately when an error occurs. Continue — Always continue execution. If there are multiple errors, the first error found is returned. Conditional — If the procedure uses ON EXCEPTION RESUME, and the statement after the error handles the error, continue. Otherwise exit. Default.

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.

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 the Database Administration Guide, Chapter 16, "Database Options" in the Adaptive Server Anywhere collection under Sybase WorkSpace Server Administration.