Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Choose Manage data type mappings from the Tools menu: REPLACE WITH THIS IMAGE: Images/Wizards/Managing Data Type Mappings.png

Image Added

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

Image Added

The top right pane displays the the From side of the mapping: REPLACE WITH THIS IMAGE: Images/Wizards/Managing Data Type Mappings_2.png

Image Added

while the bottom right pane displays the the To side of the mapping:

Note
titleNote

The various To mapping fields are only active if the respective From mapping fields are not empty, i.e. a value has been entered.

Image Added 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

...

Image Added

Click to Add a data type mapping within a data type mapping set.

...

Image Added

Click to Edit the selected a data type mapping within a data type mapping set.

...

Image Added

Click to Copy the selected a data type mapping within a data type mapping set.

...

Image Added

Click to Delete the selected a data type mapping within a data type mapping set.

...

Image Added

Click to Restore datatype mapping files.

Note
titleNote

...

  • 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
titleNote

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|