tags:

views:

247

answers:

2

We have a large homegrown ERP system written in Informix 4GL.

Currently we are running on old Sun hardware, Solaris 8, and a ten year old version of 4GL and Informix.

We need to move on, and one option obviously is to get the latest versions of 4GL & Informix, installed on new hardware (probably Linux/Intel).

However I believe there are options for migrating 4GL programmes to other development platforms. Does anyone have experience of that? If so, what platforms, how did it go, what are the pros and cons?

+1  A: 

The migration to I4GL 7.50 on Linux is almost a no-brainer. If you have a 10-year old version of I4GL, you might be using 7.30 instead of 7.31 or later. In that case, you may have to watch for the 'grand renaming' of C functions in the I4GL run-time library. If you use C code, you will need to ensure that all such files use the header 'fglsys.h'. Other than that, it should be load, compile, go.

I4GL 7.50 adds some (rudimentary) support for SOA. You can publish I4GL functions as web services, and you can have I4GL programs subscribe to web services.

If you want to keep the I4GL code but go to a different interface, the primary choices are:

The first two are commercial; the last is Open Source.

If you want to go without the I4GL code, then the world is your oyster - there are a myriad options for database and tools to access it.


From the comment, you are using I4GL 7.30 - released in 1998, I believe. If you are using routine p-code (no custom runners) then the upgrade should be a 'recompile and go' operation. If you used a custom runner, then you'd need to review your C code to ensure that you have '#include "fglsys.h" near the top of the files (but you could automate the operation to add it).

There have been various automatic translation tools to Java - one was by a company called Artinsoft and another was IBM's EGL. Suffice to say, 'there are issues'.

Jonathan Leffler
Chris Harris
Take a look at www.4js.com
Frank Computer
A: 

What's the current engine?.. Does your ERP have new requirements?.. existing limitations?.. What benefits do you expect to gain by upgrading to I4GL 7.5?.. If your app currently does everything you need it to do and works well, one factor to consider is if your current I4GL and engine are supported.

Frank Computer
Chris Harris
@Chris Harris-Perhaps you might just want to start only with 1. New hardware and 2. Upgrade IDS.
Frank Computer