Re: Informix 3.30.14 Conversion

On Mon, 5 Jan 1998, Nils Myklebust wrote: } Mike Segel <mikey@NOSPAM.KingofMyDomain.NOSPAM.Segel.com> wrote: } :Rollout wrote: } : } :> I have a client using UNIX Informix 3.30.14 on Altos UNIX, and we just } :> "tar"ed it over to a SCO box running Rel 5. When I type dbmenu, I get } :> "memory fault - core dumped". Will this version run on the new box? If } :> not, what are my upgrade options? Since it core dumps, the answer seems rather obvious -- No. } :Uhmm since when has Altos UNIX been binary compatible with SCO? } : } :Can we say do a major re-write? } } The old Altos Unix was originally based on Xenix as was SCO at some } time. They where "fairly" compatible. At some point Altos switched to } an OEM version of SCO which should be even more compatible. } However Informix 3.3... is so old I would expect any number of } problems. So, yes, a major rewrite is in order. } You could of course try to move to the ISQL product from Informix wich } might be a little simpler than a major rewrite. It would still be } quite some work though. Worse, you would still end up with an outdated } environement that is hardly supported. } } So in the end a major rewrite using modern tools like Java or some } other products would sure be the only real solution. I agree that a rewrite is in order -- if only because Informix 3.30 has no concept of century. All dates are stored in a format with just 2 digits for the year. Time is running out on Informix 3.30 applications! If you still have the old Altos box, then I have a set of tools which can be used to unload the data ready for insertion into an SQL-based database system. These can be made available if they are not already in the IIUG (http://www.iiug.org) web site. I'll need to make the SQLFMT command available too; the data files in that are a little dated (5.0x keywords, at best), but it still works. The SQLCMD command is already in the IIUG archive. These tools provide no help in converting the forms or reports. Wishing you a Happy New Year... Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>