I have setup the Informix ODBC driver v3.81 on my W2K PC to extract data into an Oracle DB. When I view the data I see most of the fields have white spaces. Is this a feature of Informix or the ODBC Driver. If I do the same with extracting into Excel the white spaces are not present just the data!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Informix ODBC extract into Oracle.
- Thread starter 2ITLTD
- Start date
Hi,
thats because the Informix ODBC is a little bit different from Oracle ODBC. To retrieve Data from an Informix DB into an Oracle or DB2 you need to check some field declarations, e.g. date, datetime, interval.
Informix, Oracle and DB2 stored their data in different ways, so if you use the Oracle ODBC it looks some kinda different, but not even okay.
There are powerful tools to migrate the Data like Ascential Datastage or Informatica which are written to convert Data from any DB into DWH's but it works also from e.g. Informix to Oracle.
regards
Uwe
thats because the Informix ODBC is a little bit different from Oracle ODBC. To retrieve Data from an Informix DB into an Oracle or DB2 you need to check some field declarations, e.g. date, datetime, interval.
Informix, Oracle and DB2 stored their data in different ways, so if you use the Oracle ODBC it looks some kinda different, but not even okay.
There are powerful tools to migrate the Data like Ascential Datastage or Informatica which are written to convert Data from any DB into DWH's but it works also from e.g. Informix to Oracle.
regards
Uwe
- Status
Similar threads
