User Settings 
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.
|
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 |
|
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 |
|
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 |
|
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.* |

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
isolation
level and
SQL
modesections of the documentation The SAP DB Database
System.
For an explanation
of the user attributes, see the
authorization
section of the Reference Manual: SAP DB.