Maintaining Database Connection Information 

Use

Use DB connection maintenance to maintain the R/3 table DBCON. This table contains information about additional non-standard database connections (such as database system, password, and so on).

Procedure

To call DB connection maintenance, choose Tools ® CCMS ® DB administration ® DB connection maintenance. Alternatively, use Transaction DBCO .

A table for DB connection maintenance appears. The table includes the following columns:

Logical name of database connection

Database system

Database user

Password to create the connection to the database

Database system-dependent information about the database connection.

Displaying Details about the Database Connection

  1. Select the entry
  2. Choose Details

Adding New Information to Database Connections

  1. To switch to change mode, choose Table view ® Display -> Change
  2. Choose New entries Alternatively, choose Copy as... to use an existing data connection as a template
  3. In the Connection name field, enter a name you choose for the logical database connection
  4. In the DBMS field enter the code for the database system (for example, ORA for Oracle)
  5. In the User name field enter the name of the database user
  6. In the DB Password field enter the password twice
  7. In the Conn.info field enter the database-dependent information for the database connection
  8. In the Reconnect type field enter the type of availability for an open database connection
  9. Choose Save

Maintaining Existing Database Connection Information

  1. To switch to change mode, choose Table view ® Display -> Change
  2. Select the entry
  3. Choose Detail s
  4. Change the existing information
  5. In the DB Password field enter the password twice
  6. Choose Save

Deleting Existing Database Connection Information

  1. To switch to change mode, choose Table view ® Display -> Change
  2. Select the entry
  3. Choose Delete