Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

Data modeling with InfoSphere Data Architect and Informix Dynamic Server

Accelerate data integration projects and create trusted information assets

Venkatesh Gopal (gopalv@us.ibm.com), Senior Software Engineer, IBM
Author Photo: Venkatesh Gopal
Venkatesh Gopal is a Senior Software Engineer working in the Data Studio team. He has over 14 years of experience in application development for databases using different technologies (Java, Microsoft and 4GLs) and also Eclipse technologies.
Srini Bhagavan (srinib@us.ibm.com), Senior Software Engineer, IBM
Srini Bhagavan
Srini Bhagavan is a Senior Software Engineer and Development Manager working in the Data Studio team. He has over 15 years of experience in database technology, Telecom, Open Source Application development and more recently in building Eclipse based administration tools for DB2, Informix and MySQL.

Summary:  This tutorial shows you how to use IBM® InfoSphere® Data Architect (IDA) (formerly IBM Rational® Data Architect) as a modeling tool for Informix® Dynamic Server (IDS), and has been updated to include information about the 7.5.1 release of IDA. Learn about the various features of IDA, including how models can be used to represent business entities, database entities, and domain entities. Follow along with scenarios and examples that reveal the benefits IDA provides specifically for IDS.

Date:  12 Mar 2009 (Published 26 Nov 2008)
Level:  Intermediate PDF:  A4 and Letter (1317 KB | 43 pages)Get Adobe® Reader®

Activity:  35825 views
Comments:  

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.

  1. Bring up the Preferences window from the top toolbar by going to Window > Preferences.
  2. 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.
  3. 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
Setting up preferences

7 of 12 | Previous | Next

Comments



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management, Rational
ArticleID=375754
TutorialTitle=Data modeling with InfoSphere Data Architect and Informix Dynamic Server
publish-date=03122009
author1-email=gopalv@us.ibm.com
author1-email-cc=
author2-email=srinib@us.ibm.com
author2-email-cc=