User Settings

Use

You can personalize the settings in SQL Studio while a session is running. These settings are stored when you exit SQL Studio.

Procedure

To change your settings, choose Session ® Settings.

You can make the following settings:

General

Store Password

The system stores the password that you used at logon for the next logon.

Confirmation for saving SQL Studio Objects

When the dialog window closes, the system asks whether you want to save the newly created SQL Studio object.

Open Form Dialog read only

Form dialogs are opened in read-only mode first.

Remove failed connection attempts from Recent Sessions list

The system deletes the failed attempts from the recent sessions list.

Identifiers in Create Dialogs uppercase

When you create a new SQL Studio object, the system automatically converts the entries to uppercase.

Result Window

Limit for long columns (Bytes)

Maximum number of bytes that can be loaded from the database for a LONG column

Limit for binary zoom (Bytes)

Maximum number of bytes that can be displayed when zooming in the LONG column of a result table

Representation of null value

How the NULL value is displayed

Clipped result view (Internal Mode)

Result set displayed in segments

Replace non chars in long columns

ASCII codes < 32 are replaced by a blank character when LONG columns are displayed.

Copy columns tab separated to clipboard

When results are temporarily stored on the clipboard, the system separates the columns with tabs.

Copy Result with Column Header

When the results are copied, the system also copies the column headers.

Append Exported Data to File

When you export a result table to a file, the content of this result table is attached to the existing file content.

Display Char Byte Column as Hex Values

Data with the data type CHAR BYTE is displayed as hexadecimal digits. If you do not choose this option, the data is displayed in binary format.

Catalog Manager

Selected table types

Specifies which table types are displayed in the Catalog Manager

Path for local folder

Path to be used to save SQL Studio Objects in a local folder

Restore catalog state

When you log on to the database again, the last Catalog Manager view is restored.

Convert input for catalog filter to uppercase

The system automatically converts filter entries in Catalog Manager to upper case

Query Dialog

Isolation Level

Isolation level for the creation of SQL statements

SQL Mode

SQL mode for the creation of SQL statements in the SQL dialog. The INTERNAL SQL mode is always used for the Form dialog and the Visual Query dialog.

If you log on to a database instance (version 7.6 or higher) with SQL Studio, you can only choose the SQL modes INTERNAL or ORACLE. The SQL modes DB2 and ANSI are no longer supported.

Execute Statements Asynchronously

SQL statements are executed asynchronously. You can specify a period of time (in milliseconds) during which SQL Studio is to be inactive while SQL statements are executed.

AutoCommit Mode

Default value for autocommit mode

Fonts

SQL Studio Font

Font type and font size for all text fields, labels, and tree views

SQL Dialog Font

Font type and font size for the SQL dialog

Result Window Font

Font type and font size for the result view

Status Window Font

Font type and font size for the status window

See also Unicode Support.

If you have the EXCLUSIVE user attribute, you cannot change the standard settings for the isolation level or SQL mode. In this case, SQL Studio automatically works with the COMMITTED isolation level and in the INTERNALSQL mode.

For an explanation of the user attributes, see the Authorization section of the SQL Reference Manual.