Procedure documentation User Settings Locate the document in its SAP Library structure

Use

You can personalize the settings in SQL Studio during operation. These settings are stored when you exit SQL Studio.

Procedure

To change your settings, choose View ® Settings.

You can now make your changes.

General

Store Password

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

Confirmation for saving SQL Studio Objects

Prompt for deciding whether a newly created SQL Studio object should be saved when you close the dialog window

Form Dialog read only

Form dialogs are opened in read-only mode

Remove failed connection attempts from Recent Sessions list

The system deletes the failed attempts from the recent sessions list

Identifiers in Create Dialogs upper case

When you create a new SQL Studio object, the system automatically converts the entries to upper case

Result window

Limit for long columns (Bytes)

The number of bytes that should be loaded from the database for a LONG column

Representation of null value

Representation of null value

Clipped result view (Internal Mode)

Result set displayed in segments

Replace non chars in long columns

ASCII-Codes < 32 are replaced by a space 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

Catalog Manager

Selected table types

Display of table types in the Catalog Manager

Path for local folder

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

Restore catalog state

The most recent view of the Catalog Manager is restored when you log back on to the database

Convert input for catalog filter to uppercase

The system automatically converts filter entries in the 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 SQL mode INTERNAL is always used for the Form dialog and the Visual Query dialog.*

Caution

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

*For an explanation of the terms “isolation level” and “SQL mode,” see the Structure linkisolation level andStructure linkSQL modesections of the documentation The SAP DB Database System.

For an explanation of the user attributes, see the Structure linkauthorization section of the Reference Manual: SAP DB.