Mapping Services 3.3.1 DML Users Guide Save PDF Selected topic Selected topic and subtopics All content 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 Click the icon. Mapping Services opens the Column Properties view. Enter values in the fields. FieldContentsNameEnter 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.LabelOptionally, enter a free-text description of this column. This text only appears on this tab.ClassSelect 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. DefinitionMost 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 containInteger: (max precision) describes the maximum number of numeric characters that a column can containReal 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 containDate 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 ColumnBy 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 selectionValue column, deselect the option 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 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. Modify the fields in the Column Properties view. 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 Select OK to validate the modified values. Mapping Services update the column properties. Add a new line Click the icon. Mapping Services adds a new line to the Table. 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: 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
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 Click the icon. Mapping Services opens the Column Properties view. Enter values in the fields. FieldContentsNameEnter 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.LabelOptionally, enter a free-text description of this column. This text only appears on this tab.ClassSelect 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. DefinitionMost 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 containInteger: (max precision) describes the maximum number of numeric characters that a column can containReal 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 containDate 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 ColumnBy 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 selectionValue column, deselect the option 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 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. Modify the fields in the Column Properties view. 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 Select OK to validate the modified values. Mapping Services update the column properties. Add a new line Click the icon. Mapping Services adds a new line to the Table. 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: 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