If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MS Access vs Informix 4GL
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 |
#2
|
|||
|
|||
MS Access vs Informix 4GL
"RJ" wrote in message ... 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 If you need information on Informix 4GL, there is plenty of information available. Here, for example: http://www-01.ibm.com/software/data/...y/4gl_750.html |
#3
|
|||
|
|||
MS Access vs Informix 4GL
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 |
Thread Tools | |
Display Modes | |
|
|