I think Application migration could be a bigger job than a database
migration.

Although recently we migrated all our application mainly 4gl from online
5.1 to 9.3 without almost no problem except for some bizarre SQLCA
constructs that just stopped working as expected and some querys who
just became slow... and needed to be optimized.

I think 4Js it's very expensive. I'll prefer queryx or Aubit.

All in all, what ever you do: TEST and test a lot... not only
developers, all the users of the application.

Chucho.


Smitty wrote:
> Our company is using Informix SE 4.0 (1990) and want to upgrade to
> Informix SE 7.x. The primary reason being so we can use ODBC to
> connect to the Windows world (to use report writers, make VB/Delphi
> front-ends, etc.). But we have 1000s of existing 4GL programs and
> need them all to work under the new version of Informix (SE 7.x).
>
> We've been told several conficting things by several different
> salesmen. For example, when we get SE 7, will we need a new version
> of the 4GL compiler? Some say our existing programs simply need to be
> recompiled with our existing 4GL compiler (c4gl Version 4.0). Some
> say we need to upgrade to a newer version of the 4GL compiler (or use
> "4Js", a similar product that can also do graphics mode). Everyone
> giving advice stands to gain financially from our decision, it's hard
> to know who honestly has our best interest at heart.
>
> Bottom Line:
> We want a version of Informix new enough that ODBC drivers exist for
> it. Informix SE 7.x sounds like that version. Do we need a newer
> version of 4GL also? And if so, do we just need a few developer
> licenses (we have 3 developers), or enough runtime licenses for each
> and every user (80 users). We have the version of 4GL that creates
> *.ec/*.c code then compiles/links that to make our executable (*.4ge),
> no "p-code" or interpreted code. Any help much appreciated!
>
> wolphie@hotmail.com
>

--


Atte,


Jesús Antonio Santos Giraldo
jeansagi@myrealbox.com
jeansagi@netscape.net

sending to informix-list