Procedure documentationConfiguring Database Studio Locate this document in the navigation structure

Procedure

  1. Choose   Window   Preferences   Database Studio  .

  2. You configure the properties of Database Studio in the following tab pages:

    Database Studio Preferences

    Property

    Description

    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:

    • Show content

    • Show definition

    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.

    SQL: Settings

    Property

    Description

    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:

    • Auto Commit Mode

    • SQL Mode

    • Isolation Level

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

    New Item Color

    Color of new elements in graphical editors

    Templates

    Property

    Description

    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

    Export/Import

    Property

    Options

    Description/Further Information

    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

    Logging

    Property

    Description

    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.

    Query Results

    Property

    Description

    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

    Note Note

    In the SQL editor, the entire row is always displayed as selected.

    End of the note.

    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

    Note Note

    Set this option for short results tables only.

    End of the note.
    Repository: Settings

    Property

    Description

    Local Folder Path

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

    Note Note

    Do not change any settings in the following sections as they currently are used for support purposes only:

    • Synchronization

    • User Management

    End of the note.
  3. To configure general attributes of the Eclipse environment, for example fonts, choose   Window   Preferences   General  .