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 icon.

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

2. 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 .

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.

2. Modify the fields in the Column Properties view.

3. 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 icon.

Mapping Services adds a new line to the Table.

2. Enter values in the cells of the line.

Remove a line

Select the line you want to delete and click .

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: