Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: Tom G on December 20, 2007, 06:12:58 am
-
We use the client access odbc driver to import an AS400 (V4R4) database schema.
The import succeeds and the database name is set correctly to DB2 (my default database), but the data types of the columns are wrong. Instead of "DECIMAL" it uses "numeric" and omits the scale and precision (well, they are there but not visible). The first type is defined out-of-the-box as a DB2 type the latter is unknown for DB2.
I just found a "workaround" that works in our case. I reset the DBMS options of the package to another database e.g. SQL Server 2005 and let EA convert everything... SQL Server knows the (or rather "a") numeric type and shows a scale and precision for it. Then I convert back to DB2 and there they are all my DECIMAL columns (including scale and precision).
Anyone any idea what might go wrong here ? I have the impression it uses the right DB but the wrong types or would this rather be an ODBC problem ? Don't know how they map those types...
TG