Re: Upgrading SCO Informix 3.30.12 to v4.00 & v7

Robert Weiner <robert@progplus.com> wrote: :Hello, : :I am looking for some automated tools to help me upgrade ace reports, :forms, informer and dbstatus statements from : SCO Informix 3.30.12 (yes, the old xenix version) :to a more modern (but still old) Informix like : Informix 4.00.UE1 :or to current Informix : Informix SE 7.x and SQL 6.x It would make no significant difference when it comes to the work involved which of these versions you upgrade to. Obviously you should convert to the newest versions to have full support and the latest functionality available. :We own the 4.00 version and while the forms converted from 3.30 :without too much difficulty, I ran into a problem trying to :convert a couple thousand 'aceprep' reports into 'saceprep' :reports due to the syntax differences. Since dbstatus & informer :disappeared in v4, there was also a problem converting hundreds of :these non-sql scripts. We are now using a SCO 5.0.0 platform and :the 3.30 version is at its limits. : :I came to the conclusion that I'd need an automated tool to help. :Informix told me they provide no such tools (which I still find :hard to believe), except for one which converts the database itself :(and that one does work). I also had such an application but at the time i selected to redo the whole application in 4GL. That gave such a vast improvment in functionality available and the type of user interfaces I could program I found it more than worth the effort. For reports I could use some parts of the ace reports wrapped in a 4GL program. For the informer scripts I rewrote everything, but conceivably you could translate them into sql and execute them via dbaccess or better inside a 4GL program. Your application seems rather large though, so I can see your reluctance to do such a thing. I have never heard of any automated tools that could help you and am quite sure there are non. Sorry, but the by hand approach seems to be the only one. This beeing the case you might also want to evaluate a full rewrite using GUI tools like VB, Delphi or even Java. :Is there any freely available or other professional product on the :market which can convert the old 3.30 reports and other :dbstatus/informer scripts into the proper syntax for later Informix :versions? ie. Old Informix to SQL converter? : :Preferrably, I'd like to jump directly to the latest SE 7.x & SQL 6.x :at this point and start using current products again. : :(Please cc: your reply via email as I don't frequent this newsgroup.) I considder it a slightly bad form to ask for free advice and state in effect you will never do anything in return, but... Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org