Create an active database dictionary record

This procedure assumes the Service Manager system has table create-alter-drop-rights to the RDBMS system. If Service Manager does not have table create-alter-drop-rights, your database dictionary record remains inactive and mapped to null tables until you activate it. If your system does not have table create-alter-drop-rights to the RDBMS, we recommend you enable the option to create DDL to provide to your RDBMS administrator. You can then activate the database dictionary record after your RDBMS administrator has created the tables and columns specified in the DDL.

For Windows clients:

To create an active database dictionary record:

1. Log on to the Service Manager system with a system administrator account.
2. In the System Navigator, click System Definition > Tables.
3. Right-click Tables, and then click New Table.
4. Type the Table name.
5. Add one field for each RDBMS column you want to add.
6. Add a unique key to the database dictionary record.
7. Click OK.

For Web clients:

To create an active database dictionary record:

1. Log on to the Service Manager system with a system administrator account.
2. In the System Navigator, click Tailoring > Database Dictionary.
3. Type the name of the new table in the File Name field, and then click the New icon.
4. Add one field for each RDBMS column you want to add.
5. Add a unique key to the database dictionary record.
6. Click OK.

Related topics

Database dictionary
Database dictionary records
Data persistence

Create a database dictionary record by importing RDBMS columns
Enable DDL logging of database dictionary changes