ASA Connection Level Options

The ASA connection-level options determine the default values for the launch configuration of newly created Adaptive Server Enterprise procedural objects and default values for SQL Editor, SQL File Editor, and SQL Scrapbook.

Table 1. Connection level options: Arithmetic
Property Description
ANSI Integer Overflow Integer overflow errors cause a SQLSTATE = 22003 - overflow error (SQL/92 behavior). Default is off.
Divide by Zero Division by zero reports an error with SQLSTATE 22012. Do not select this option to return NULL. Default is on.
Table 2. Connection level options: On Transact-SQL Error
Property Description
On Transact-SQL 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. This selection is the default.

Table 3. Connection level options: Transactions
Property Description
Chained

Select this option for chained mode.
Isolation Level

Select the isolation level:


  • Isolation Level 0 – allow dirty reads, nonrepeatable reads, and phantom rows.

  • Isolation Level 1 – prevent dirty reads, allow nonrepeatable reads, and phantom rows. Default for JDBC connections.

  • Isolation Level 2 – prevent dirty reads and guarantee repeatable reads, allow phantom rows.

  • Isolation Level 3 – serializable: do not allow dirty reads, guarantee repeatable reads, and do not allow phantom rows.

Table 4. Connection level options: Miscellaneous
Property Description
ANSI NULL Any comparisons with NULL using = or != evaluate to unknown. Default is on.
Quoted Identifier Strings enclosed in double quotes are interpreted as identifiers. Default is off for JDBC connections.
Related tasks
Sybase IQ Connection Level Options
Creating a Launch Configuration for Routine Procedural Objects
Related reference
Connection Level Options
ASE Connection Level Options

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com