Background documentationdb_connect Locate this document in the navigation structure

 

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.

Prerequisites

  • 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.

Structure

db_connect <user_identification>

<user_identification> :: = <user_spec> | <user_type>

<user_spec> :: = <database_user>,<database_user_password>

<user_type> :: = user-type=<value>

Options

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

Result

In the event of errors, see Reply Format.

More Information

Database Manager CLI Tutorial,

Backup

Restoring the Database

Executing a Succession of Database Statements

Glossary, Database Session