Extract data from Informix
I'm trying to extract data from an Informix database. To do so, I installed the informix client 2.9 as recommanded in DI manuals, I can establish the connection successfully through ODBC, but when I try to read the table data, I get the following error code: restricted data type attribute violation (-11013).
I've done some tests to narrow down the problem, and I found out that the error is caused by a column of type "serial8" in the informix database (that i need to extract, otherwise the error won't occur). I tried to import it as an integer but that doesn't work neither.
Any ideas about this issue please ?