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:
REPLACE WITH THIS IMAGE: Images/Wizards/Managing Data Type Mappings.png
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.
REPLACE WITH THIS IMAGE: Images/Wizards/Managing Data Type Mappings_1.png
The top right pane displays the From side of the mapping:
REPLACE WITH THIS IMAGE: Images/Wizards/Managing Data Type Mappings_2.png
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. |
REPLACE WITH THIS IMAGE: Images/Wizards/Managing Data Type Mappings_3.png
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
REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png
Click to Add a data type mapping within a data type mapping set.
REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.png
Click to Edit the selected a data type mapping within a data type mapping set.
REPLACE WITH THIS IMAGE: Images/Common_Icons/copyqueryicon.png
Click to Copy the selected a data type mapping within a data type mapping set.
REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.png
Click to Delete the selected a data type mapping within a data type mapping set.
REPLACE WITH THIS IMAGE: Images/Common_Icons/undo.png
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 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 an 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|