Update the data type of a database dictionary field

Applies to User Roles:

System Administrator

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 changes 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 changes after your RDBMS administrator has created the tables and columns specified in the DDL.

To update the data type of a database dictionary field:

  1. Log in to the Service Manager system with a system administrator account.
  2. Click System Definition > Tables.
  3. Double-click the table name you want to edit.

    Note: Each table name is actually a database dictionary record.

  4. Click the Fields and Keys tab.
  5. Click the field name you want to edit.
    The General properties pane opens.
  6. Select a new value from the Data type field.

    A confirmation window opens.

    Note: You cannot use the drop-down list to change a scalar field to an array or structure. Instead, you must add a new array or structure.

  7. Click OK to verify the data type change.
  8. Click Save to update the database dictionary record.

Related topics

Database dictionary
Master data records

Create an active database dictionary record
Import RDBMS columns into an existing database dictionary record