Show name of database in editor title

Database names are displayed in editor titles.

Identifier upper case

Names of database objects can only be entered in upper case (all caps).

Retrieve all database catalog objects

All database objects are displayed.

Show only own database catalog objects

Only the database objects that belong to the current database user are displayed.

Show database catalog sorted by schema

If you choose this setting, the database objects are displayed in the Explorer sorted by the schema they belong to. Otherwise, the database objects are displayed in the Explorer sorted by the user they belong to.

Default action for database tables:

Action which is carried out when double-clicking a database table.

Show console for database management commands

Internal commands are displayed in a console window.

Stop Batch SQL Statement Execution on Error

When you execute a list of SQL statements that is separated by comment characters, the system stops the execution of the SQL statements when an error occurs.

Clear SQL Editor Log before SQL Statement Execution

The log from the last executed SQL statement is deleted before the next SQL statement is executed.

Connection Parameters for SQL Window:

Connection parameters that the system uses to execute SQL statements from the SQL editor:

New Item Color

Color of new elements in graphical editors

The settings always refer to the editor type currently open.

For more information, see the Eclipse documentation.

Name

Word to be completed when you press the key combination CTRL+Space

You can create more than one template with the same name. If more than one template exists for one word, the system displays a list of values that you can select to complete the word.

Context

Editor in which you can use the template

Description

Description

Automatically Insert

If selected, code assist will automatically insert the template if it is the only proposal available at the caret position.

More information: Eclipse documentation at http://www.eclipse.org/documentation

Pattern

Values that should be available for completing the word

Package Directory

-

Directory in which the system (temporarily) saves the exported data

Data File Formats

File Format

Loader,

LOB Files

Loader, Exporting and Importing LOB Values

Data Field Formats

Text Fields

Loader, Data Format

Data/Time Formats

Representation of special values

Number value format

Error Handling

Primary key constraint

Defines how duplicated data records are dealt with on import

Maximum allowed errors for a single command

Determines how many errors must occur before the export/import process is aborted

Database Connection

Autocommit Mode

Glossary, AUTOCOMMIT Mode

SQL Mode

Glossary, SQL Mode

Isolation Level

Glossary, Isolation Level

ERROR

The system logs errors only.

WARNING

The system logs errors and warnings.

INFO

The system logs errors, warnings, and information messages.

TRACE, DEBUG, ALL

The system logs errors, warnings, and information messages.

Limit for LOB Columns (Bytes)

Maximum number of bytes that Database Studio should load from the database for one LOB column

Limit for Zoom (Bytes)

Maximum number of bytes that Database Studio should display when you zoom in the LOB column of a results table

Representation of Null Values

Characters with which Database Studio displays NULL values

Separate Exported Data with

Separators between values exported from the SQL editor

Replace Non Chars in LOB Columns

Characters in LOB columns that cannot be displayed are replaced by blanks

Copy Only Cell in Row Selection

Determines whether the entire row or only the selected cell is copied when you copy from the results table

Copy Result with Column Header

Determines whether column headers are also copied when you copy from the results table

Append Exported Data to File

When you export a result table to a file, the system attaches the content of this result table to the existing file content.

Display Char Byte Value as Hex

Database Studio displays data of the data type CHAR BYTE as hexadecimal digits. If you do not choose this option, Database Studio displays this data in binary format.

Determine Last Row in Result

Determines whether Database Studio defines the number of result rows before a results table is displayed

Local Folder Path

Path to the local folder which is used as Local User Folder in the My Repository area of the Exporer.