Logging on to a Database Instance


To use the SQLCLI interactively (in session mode), log on to a database instance as a database user: This opens a database session.


The specified user is a database user.

One Step Logon

Log on to the database instance:

sqlcli [<options>] -d <database_name> -u <database_user>,<database_user_password>


Call options for the SQLCLI program


Name of database instance


Name of the database user

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


Password of the database user

One step logon to the database instance DEMODB on the computer PARMA as database user MONA with the password RED:

sqlcli -n PARMA -d DEMODB -u MONA,RED

To log on using a user key <user_key>, enter the following command:

sqlcli [<options>] -U <user_key>

Two Step Logon

Start the SQLCLI:

sqlcli [<options>]

Log on to the database instance:

\c [<options>] -d <database_name> -u <database_user>,<database_user_password>


You have opened a database session and can now execute commands interactively.

See also:

Overview of the SQLCLI Commands