Re: Upgrade from 5 to 7

In article <335CEB26.751A@ana.med.uni-muenchen.de>, Richard Spitz <spitz@ana.med.uni-muenchen.de> wrote: >John F. Tosh wrote: >> >> I am currently creating a document to support my reasoning for upgrading >> our Informix database from version 5 to 7 [...] > <snip> >3) We have tons of legacy code written in I4GL 4.1. All this code > would have to be re-compiled with I4GL 6.x and thoroughly tested, > since there ARE incompatibilities. The time required to do this > would be several weeks, depending on how many people we could > spare. No way with our present staffing. > Without recompilation, we would suffer serious performance hits > by having to go through the "relay module". We've recently done the 4.1 -> 6.04 trip. While the code has to be recompiled, the incompatibilities we faced were few. In fact, we found only two. 1. minor one relating to 'SKIP TO TOP OF PAGE' in report functions. 2. potentially serious one (but I-tech support says that this is specific only to 6.04.UC1 (pcode 602)) - If a WHERE clause uses a variable which is defined as a VARCHAR (we use the LIKE statement as far as possible when defining variables), the SQL stmt 'fails'. Change the variable defn. to CHAR and everything's OK. P.S We have about 700,000 LOC (I think it would cover most potential incompatibilities). ----------------------- Rudy Fernandes GIC, Kuwait OL 7.20UC4, 4GL 6.04UC1 -----------------------