Combine DMS Items

You can use the Client Configurator to combine DMS items into a single column in the relational database by merging or by concatenating them. If the items exist side-by-side in the relational database, you can use the Merge option. You can use the Concatenate option for non-adjacent items if both items are of the same type (numeric or alpha).

Caution: Make this type of change only before cloning the data source. Otherwise, you may need to reclone.

To concatenate items

1. In the Explorer view, right-click a data source and choose Customize Data Source.
2. Decide the order in which you want the concatenated items to appear.
3. In the DMSII view, right-click the DMS item you want to appear first in the column, and choose Concatenate Item.

   The Concatenate With Item property appears in the DMSII Properties view.

4. In the DMSII Properties view, click the Values column next to Concatenate With Item. From the list, select one of the available DMS items.
5. To undo your changes, right-click the DMS item and select Discard Changes, or select Concatenate Item a second time.
6. In the toolbar, click Save .
7. In the toolbar, click Refresh Relational to update the Relational view.

After you customize a data source, the Client Console will notify you that you must generate scripts. See Define/Redefine and Generate Scripts.

To merge items

Caution: Merging items can cause problems if a DMSII reorganization relocates one of the merged items. When possible, concatenate items instead. This option is included primarily for compatibility with older systems and as a method for combining three items (when used in conjunction with concatenation).

1. In the Explorer view, right-click a data source and choose Customize Data Source.
2. In the DMSII view, right-click the DMS item that occurs first in the list and choose Merge Item.
3. In the toolbar, click Save .