The Sybase IQ connection-level options determine the default
values for the launch configuration of newly created Sybase IQ
procedural objects and default values for SQL Editor, SQL File Editor, and SQL Scrapbook.
Note: Connection Level options are server settings.
Table 1. Arithmetic options (version 12.x only)
Property
|
Description
|
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 select this option
to return NULL.
Default is on.
|
Table 2. On TSQL error options
Property
|
Description
|
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. This selection is the default.
|
Table 3. Transactions options
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. Miscellaneous options
Property
|
Description
|
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.
|