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.
Log on to the database instance:
sqlcli [<options>] -d <database_name> -u <database_user>,<database_user_password>
<options> |
Call options for the SQLCLI program |
<database_name> |
Name of database instance |
<database_user> |
Name of the database user See Concepts of the Database System, Conventions for User Names and Passwords |
<database_user_password> |
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>
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