|
Edit the Server Properties to use Advanced
Properties in Aqua Data Studio 7.5 :
- Locate the Server in the Server Browser.
- Right Click on the Server - A Popup Menu Appears.
- Click on the Item which displays Server
Properties.
- Go to the Advanced Tab and make changes in the
Options.
With options in Advanced properties of a
Server, you can :
- Change Transaction Isolation Modes.
- Driver Parameters.
- Enable Database Filters in Query Analyzer.
- Change Read Only / Read- Write Mode.
- Change Object Folder Display.
- Txn 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.
- Driver Param: This option is to allow a user
to specify extra JDBC parameters that a user might want use in
estabilishing a connection.
- Charset: Character set used for the
connection.
- Set quoted_identifier: Causes connection to
follow the SQL-92 rules regarding quotation mark delimiting
identifiers and literal strings.
- Set ansi_nulls: Causes connection to follow
SQL-92 compliant behavior of the Equals (=) and Not Equal to
(<>) comparison operators when used with null values.
- Set ansi_null_dflt_on: Causes connection
behavior to override default nullability of new columns when the
ANSI null default option for the database is false.
- Set ansi_padding: Changes connection behavior
in the way the column stores values shorter than the defined size
of the column, and the way the column stores values that have
trailing blanks in char, varchar, binary, and varbinary data.
- Set ansi_warnings: Specifies SQL-92 standard
behavior for several error conditions.
Tip : Using the
dropdown at the bottom of the Advanced Tab, quickly change your
Object Display in the Server Browser.
|
|
