You open a session with the database. You can use this session to execute administrative commands and to transfer SQL statements to the database.
You can log on with the user name and password of a database user, or with a user type. If you do not specify a database user, the data of the first DBM operator registered on the database computer is used to log on.
The database session is linked with a User-Task of the database. You can configure the maximum number of simultaneous database sessions possible specifying the value of the general database parameter MaxUserTasks.
You have the server permission AccessSQL or AccessUtility.
You have the user permissions required to execute SQL statements in the database.
The database is in the ONLINE or ADMIN operational state.
You are working in the script mode or the session mode of Database Manager CLI.
db_connect <user_identification>
<user_identification> :: = <user_spec> | <user_type>
<user_spec> :: = <database_user>,<database_user_password>
<user_type> :: = user-type=<value>
Option |
Description |
---|---|
<database_user> |
Name of the database user |
<database_user_password> |
Password of the database user |
user-type=<value> |
User type, possible values for <value> are: DBM: DBM operator DBA: database system administrator SAP: database user of the SAP application |
In the event of errors, see Reply Format.
Database Manager CLI Tutorial,
Executing a Succession of Database Statements
Glossary, Database Session