Page History
...
- Transaction Isolation Level: Support for setting Transaction Isolation Level.
- TRANSACTION_NONE - A constant indicating that transactions are not supported.
- TRANSACTION_READ_COMMITTED - A constant indicating that dirty reads are prevented; non-repeatable reads and phantom reads can occur.
- TRANSACTION_READ_UNCOMMITTED - A constant indicating that dirty reads, non-repeatable reads, and phantom reads can occur.
- TRANSACTION_REPEATABLE_READ - A constant indicating that dirty reads and non-repeatable reads are prevented; phantom reads can occur.
- TRANSACTION_SERIALIZABLE - A constant indicating that dirty reads, non-repeatable reads, and phantom reads are prevented. - JDBC Escape Processing: Allows JDBC driver to perform escape sequence before sending the SQL code to the server.
- Use iAnywhere Driver: Allows using the iAnywhere Driver if the user has placed this driver in <ADS_HOME>/lib/drivers.
(see here for more information on downloading and using the Sybase iAnywhere Driver) - Always Display Column Name in Results: Allows to show/hide column names in query results.
- Enable DB Filters for Query Window: Enables/Disables db filters for query windows using this connection.
- Only Display Databases that User has Access to: Displays only the databases the current user (from the Login Name on the General tab) has access to within the schema browser.
- Set quoted_identifier: Causes connection to follow the SQL-92 rules regarding quotation mark delimiting identifiers and literal strings.
- Query Temp Space Limit: Allows specifying the maximum estimated amount of temporary space before a query is rejected.
- Fetch Size: Determines the Fetch Size (number of rows physically retrieved from the database at one time by the JDBC driver).
- Connections Pooled: Enables connection pooling. Read more about connection pooling here.
Force Auto-Commit: When this option is selected, it sets auto-commit to TRUE for any Query Window to this server and disables the icons on the toolbar, regardless of the option in File > Options > Query Analyzer > [DATABASE] > [Auto Commit].
- Data Warehouse Mode: Read Only or Read/Write.
- Object Folder Display: [Default], [Name], [Schema].[Name] or [Name]([Schema]) sets how the Schemas will be displayed.
- Object Folder Schema Folder Grouping: Default, Yes, or No. Schema Folder Grouping makes finding tables much easier because it groups them instead of showing each object individually.
...
For more information, see Connection Monitor.