Add a User Column

Use this procedure to add columns to tables in the relational database that contain additional information. User columns are added to the end of a table, after the DMSII data.

To add a user column to the entire data source, use the Client Configuration dialog box. To add user columns to specific tables, use the Client Configurator. We recommend that you add user columns before you clone your data source.

To add global user columns

  1. In the Explorer view, right-click a data source and choose Customize Data Source.
  2. In the DMSII view, right-click the data source and choose Client Configuration.
  3. In the Client Configuration dialog box, click the plus (+) sign next to Customizing and then select User Columns.

    Note: For a full description of the available options, in the lower-left corner of the Client Configuration dialog box, click the Help (?) button.

  4. Select one or more of the available user columns, and then click OK.

To add user columns to a specific data set

  1. In the Explorer view, right-click a data source and choose Customize Data Source.
  2. In the DMSII view, expand the data source and select a data set.
  3. In the DMSII Properties view, under User Columns, select one or more of the available types of user columns.
  4. To remove user columns you don't need, deselect them.
  5. In the toolbar, click Save Save button.