What is the difference between Version 7 and Version 10 IDS?

Posted in 2006

Michael Andreas — Mon, 30 Jan 2006 09:10:09 +0100 — source: Usenet: comp.databases.informix

Hi, using the following SQL-Command I copy very fast a lot of rows from a INFOMIX DB (source) into a ACCESS DB (destination): INSERT INTO tab SELECT * FROM [ODBC;DSN=DB;UID=name;PWD=test;].tab WHEREtab_typ = 50; After changing the IDS Server from version 7 to version 10 I allways get the message "Types incompatible". Why? The column-types are serial, integer and char. Is there anyone who is able to help me? thanks michael