Logging on to a Database Instance

Use

You log on to a database instance. This opens a database session.

Prerequisites

?     You have called Web SQL Studio.

?     The database instance is in the ONLINE operational state.

If the database instance is not in the ONLINE operational state, use the Database Manager to start the database instance. See:  

Database Manager CLI, db_online

Database Manager GUI, Monitoring the Operational State

Procedure

...

       1.      Enter the following data.

Data for Logging On to the Database Instance

Name

Description

Server Name

Name of the database computer

You can leave this field empty if the database instance is located on the local computer.

Database Name

Name of database instance

User Name

Name of the database user

Password

Password of the database user

The database system converts all letters to uppercase. To enter lowercase letters and special characters, enclose your entry in quotation marks.

See Concepts of the Database System, Conventions for User Names and Passwords

       2.      Optional: To change the properties of the database session, choose Extended. Change the properties you wish to change.

Properties of the Connection to the Database Instance

Name

Default Value

Description

Database Type

MaxDB

Database instance type

Auto Commit

On

AUTOCOMMIT mode

SQL Mode

Internal

SQL mode

Isolation Level

Read committed

Isolation level

For more information, see the glossary.

       3.      Choose Logon.

Result

You have opened a database session. The main page of Web SQL Studio is displayed (see Screen Areas in Web SQL Studio).