Split a DMS Item

Use this option as an alternate method of mapping variable format data sets to tables in the relational database. The fixed parts of variable format records are stored in the table for type 0 records; the variable parts of the records and keys are stored in tables for other types of records.

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

To split a single item into two columns

  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 and choose Split Item.
  3. In the toolbar, click Save and then click Refresh Relational.

    In the Relational view, two new columns are added (column_x1 and column_x2) to replace the original column.