Re: Inporting Data from Informix 4GL to some envirnment in a PC

On 12 Jun 97 at 10:18, Antonio Abreu wrote: > Anyway I think this is a nice place to ask for some help. Very kind of you to say so! :-) > I have a DataBase in a Olivetti Unix Station that has an application > written in Informix 4GL (I know that this is old Informix), and I > woul like to read all the data to a PC, and then build some > application using Delphi 2.0. > > I think it is possible to read the data in three ways: > * wite a C application that reads and converts the data for some > known format (in PC). I think this is old style and as so I would > like to avoid it. Yes, yes and yes. :-) > * use Q+E that uses Informix data remotely. I must > say that I don't know the state of the art about Q+E. In 1991 some > friends of mine do it this way. Is this a good way of doing things? > I think this involves a lot of programming... Q+E *is* an ODBC driver isn't it? > * Using a particular > driver from OBDC. Is this possible? I am asking because I don't have > this driver in my OBDC. If there is such a driver, can I get it from > you with some short explanations about how to interface with the > driver? If you want to use ODBC, you might have a problem accessing older Informix databases. They only became generally available from version 5.x on. If you can find an ODBC driver, why not just run your Delphi application on a client-server basis against the existing Informix database? Another idea you might find useful is to examine the product to see if a utility called dbexport exists. This will unload the database for you. Another option is to see if a tool called dbaccess or isql is on the machine. These have a "Query-language" option in which you can write SQL scripts to UNLOAD individual tables. > Note, if there is some bibliography that is good for my state of > knowledge, I would like you to pass the link. Check out http://www.iiug.org HTH. -- Ciao, Billy Nose to the ground and ear to the grindstone in: Kuwait, 46 Degrees Celsius