Users are able to configure data type mappings to operate any way they wish. This is achieved using the Data type mappings manager activated from the Tools menu.
Choose Manage data type mappings from the Tools menu:
The Data type mappings manager displays the data type mapping sets in the left pane. Each mapping set contains a list of mappings, which are displayed in the right pane.
The top right pane displays the From side of the mapping:
while the bottom right pane displays the To side of the mapping:
Note
The various To mapping fields are only active if the respective From mapping fields are not empty, i.e. a value has been entered.
The matching mechanism of the data type mappings operates as follows:
- * matches NULL, Numeric value or text string
- 5-* matches N > 4
- *-5 matches N <= 5
- null matches NULL
- Text string 1 identical to text string 2
Icons | Description |
|---|---|
| Click to Add a data type mapping within a data type mapping set. |
| Click to Edit the selected a data type mapping within a data type mapping set. |
| Click to Copy the selected a data type mapping within a data type mapping set. |
| Click to Delete the selected a data type mapping within a data type mapping set. |
| Click to Restore datatype mapping files. |
Note
- The Scale is the number of digits to the right of the decimal point in a number.
- The Precision is the total number of digits in a number.
Note
The following generic data types in 3D are used for generated attributes so they can be mapped to the correct RDBMS target.
- tgt_integer
- tgt_char
- tgt_varchar
- tgt_date
- tgt_datetime|