Manage Tables

Overview

Add a new column

Remove a column

Modify column properties

Add a new line

Remove a line

Enter table values

Overview

You manage the format and content of Tables on the Definition tab of the Tables Properties view in a DML Mapping Project.

Add a new column

  1. Click the Add column icon icon.

Mapping Services opens the Column Properties view. Enter values in the fields.

FieldContents

Name

Enter a name for the column or accept the default. This name is the logical name that is used to refer to the column throughout the software. Although a column is not an object, follow the object naming conventions.

Label

Optionally, enter a free-text description of this column. This text only appears on this tab.

Class

Select the of the data that the column can contain. On the Definition tab, Mapping Services displays the letter that represents the DML: data class next to the name of the column and in parentheses.

Definition

Most data classes have one or two physical properties. When you select a data class in the   field, Mapping Services displays the default value of the appropriate physical properties and an abbreviated form of the property name in parentheses.

The default values of most of properties are values that optimize the performance of the Map Engine. You cannot modify a property definition that is displayed in gray.

Data classes have the following corresponding properties:

  • String: (max length) describes the maximum number of characters that a column can contain
  • Integer: (max precision) describes the maximum number of numeric characters that a column can contain
  • Real number:
  • (max precision) describes the maximum number of numeric characters that a column can contain
  • (max mantissa) describes the maximum number of significant digits that a column can contain
  • Date and time (yyyy-dd-mm hh:mm:ss +/- hh:mm) describes the format of dates. [FOR DETAILS:  ]
  • Boolean: No property applies to Boolean data.

Key Column

By default this option is selected to indicate that the column is a Key column that can be used by Table Functions to select the data in the lines of the Table.

If you want the column to be a:

  • Key column, accept the default selection
  • Value column, deselect the option

  1. Select OK to validate the values.

Mapping Services generates a new column in the Table.

Remove a column

Select the column you want to remove and click Delete column icon.

Mapping Services deletes the selected column.

Modify column properties

  1. To modify the properties of a column, click anywhere in the column to select it and then click the  icon.

Mapping Services opens the Column Properties view for the selected column.

  1. Modify the fields in the Column Properties view.
  2. Field Contents

    Name

    Name for the column. This name is the logical name that is used to refer to the column throughout the software.Although a column is not an object, follow the object naming conventions.

    Label

    Free-text description of this column. This text only appears on this tab.

    Class

    of the data that the name that is used to refer to the column throughout the software. Although a column is not an object, follow the object naming conventions.

    Label

    Free-text description of this column. This text only appears on this tab.

    Class

    of the data that the column can contain. On the Definition tab, Mapping Services displays the letter that represents the data class next to the name of the column and in parentheses.

    Definition

    Most data classes have one or two physical properties. When you select a data class in the data class field, Mapping Services displays the default value of the appropriate physical properties and an abbreviated form of the property name in parentheses.

    The default values of most of properties are values that optimize the performance of the Map Engine. You cannot modify a property definition that is displayed in gray.

    Data classes have the following corresponding properties:

    • String: (max length) describes the maximum number of characters that a column can contain
    • Integer: (max precision) describes the maximum number of numeric characters that a column can contain
    • Real number:
    • (max precision) describes the maximum number of numeric characters that a column can contain
    • (max mantissa) describes the maximum number of significant digits that a column can contain
    • Date and time (yyyy-dd-mm hh:mm:ss +/- hh:mm) describes the format of dates.[FOR DETAILS:  ]
    • Boolean: No property applies to DETAILS:  ]
    • >Boolean: No property applies to Boolean data.

    Key Column

    By default this option is selected to indicate that the column is a Key column that can be used by Table Functions to select the data in the lines of the Table.

    If you want the column to be a:

    • Key column, accept the default selection
    • Value column, deselect the option
  3. Select OK to validate the modified values.

Mapping Services update the column properties.

Add a new line

  1. Click the Add element icon icon.

Mapping Services adds a new line to the Table.

  1. Enter values in the cells of the line.

Remove a line

Select the line you want to delete and click Delete element icon.

Mapping Services deletes the selected line.

Enter Table values

To enter values in a Table, select a cell of the Table and directly enter the data. The data must correspond to the data type defined for the cell in the corresponding column properties.

The values you enter in a:

  • Key-type column can be used by Table Functions as data selection criteria
  • Value-type column, can be used via Table Functions to map or validate messages
  • Start Date or End Date column, can be used by Table functions as data selection criteria

Related topics

Use Tables

Related Links