Show TOC

Procedure documentationLogging on to the Database Locate this document in the navigation structure

 

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

Prerequisites

  • You have called Web SQL Studio.

  • The database is in the ONLINE operational state.

    Note Note

    If the database is not in the ONLINE operational state, use the Database Manager to start the database. Refer to Database Manager CLI, db_online

    End of the note.

Procedure

  1. Enter the following data.

    Data for Logging On to the Database

    Name

    Description

    Server name

    Name of the Database Computer

    Note Note

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

    End of the note.

    Database Name

    Name of the database

    User Name

    Name of the database user

    Password

    Password of the database user

    Caution Caution

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

    End of the caution.

  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

    Name

    Default value

    Description

    Database Type

    MaxDB

    Database type

    Auto Commit

    On

    AUTOCOMMIT mode

    SQL Mode

    Internal

    SQL Mode

    Isolation Level

    Read Committed

    Isolation level

Result

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