|  | Modifying data type mapping preferences
There is extensive support for the Informix data types when you are
working at the physical model level, including BYTE, TEXT, NCHAR,
NVARCHAR, LVARCHAR, BOOLEAN, INTERVAL, DATETIME in addition to the
other basic types as shown in the
Appendix.
You can set up the type conversions to be used when going from logical
to physical models and physical to logical models by configuring them
in the IDA preferences for a particular database. You can also add to
the list if you find something is missing from the pre-existing
list.
- Bring up the Preferences window from the top toolbar by going to
Window > Preferences.
- Navigate the tree by expanding the Data Management section
(Figure
32), then
going to Transform > Data Type Map, and then
click on Logical to Physical . This brings up a set of type
mappings on the right side.
- Select Informix from the Database vendor type drop-down list, and
then click in the Physical Data Type field to change the mapped-to
data type. For this example, modify the default TIMESTAMP mapping
to map to a physical data type of DATETIME YEAR TO SECOND then
click on Apply and OK. This will be used for all future
type mappings.
Figure 32. Setting up
preferences
| |
|
