NewEra and Oracle 7/8

Hi, We have a large application written in NewEra and installed in a large client base world wide, ALL of which are using informix backends. We now have a new client, wishing to use Oracle 7/8 as the Backend. We have having great problems mapping Informix NewEra data types to Oracle data types. Anyone ever tried this before, it's the windows developed in window painter against an Informix database that cause the most problems. Our Business classes can be easily changed. Any assistenace appreciated, Regards Andy Anelay Topas International

On Tue, 9 Mar 1999 17:29:56 -0000, "_CEL_" <CLey@topas.co.uk> wrote: >Hi, > We have a large application written in NewEra and installed in a large >client base > world wide, My commiserations. ALL of which are using informix backends. We now have a new >client, > wishing to use Oracle 7/8 as the Backend. Talk them out of it. They will thank you. *GIVE* them Informix if you have to. Just include it in the price :-) We have having great problems >mapping > Informix NewEra data types to Oracle data types. Which ones? If it's Informix DATETIME or INTERVAL data types, you're SOL. There *are* no equivalents. Nasty workarounds, but no equivalents. Oracle also doesn't really have number types in the same manner as Informix does. They just pretend. > Anyone ever tried this before, it's the windows developed in window >painter against > an Informix database that cause the most problems. Our Business classes >can be > easily changed. If you point a JDBC tool at the databases & check what Java thinks the classes are, thet'll help you as well. Or get a reverse-engineering tool and point it at the Informix schema, then tell it to generata an Oracle 7/8 schema. ER/Studio can do this, IIRC. Lotsa luck and better start thinking where you're going to go from NewEra. Peter Wiley