MS Access vs Informix 4GL

  • Thread starter Thread starter RJ
  • Start date Start date
R

RJ

Hello all;

I am quite comfortable using Access via ODBC however I am now looking at a
new position using Informix 4GL on top of SQL Technology on an HP9000 server.
Has anyone had experience with Informix from a queries, data reporting,
manipulation and GUI design perspective? Is it similar to Access and what
would be the reasons for using Informix rather than Access. I am plowing
through SQL for dummies in the case that I might have to take hours to do
what I can do in minutes with Access.

Any info would be greatly appreciated!!
Thanks

RJ
 
RJ said:
Hello all;

I am quite comfortable using Access via ODBC however I am now looking at a
new position using Informix 4GL on top of SQL Technology on an HP9000
server.
Has anyone had experience with Informix from a queries, data reporting,
manipulation and GUI design perspective? Is it similar to Access and what
would be the reasons for using Informix rather than Access. I am plowing
through SQL for dummies in the case that I might have to take hours to do
what I can do in minutes with Access.

Any info would be greatly appreciated!!
Thanks

RJ
Click to expand...

If you need information on Informix 4GL, there is plenty of information
available. Here, for example:

http://www-01.ibm.com/software/data/informix/pubs/library/4gl_750.html
 
I've used Informix as a server database with Access front ends. It was
solid, stable, and we were able to obtain satisfactory performanc using ODBC
drivers (the only exception was on some reports with complex queries where I
had to create some Informix views -- which was not difficult). But, my last
use of it was about ten years ago, prior to Informix being bought by IBM.
I'm sure there have been changes since then.

My understanding is that 4GL is an application development tool, but I never
used it... as I said, it was a client-server structure with Access as the
client.

Informix is a server database, similar to MS SQL Server or Oracle. It's not
a matter of "using Informix rather than Access"... perhaps a better question
would be about using 4GL instead of Access, and I could not address that
one.

Larry Linson
Microsoft Office Access MVP
 
Back
Top