Inporting Data from Informix 4GL to some envirnment in a PC 
Author Message
 Inporting Data from Informix 4GL to some envirnment in a PC

Dear Friend,

First of all, I would like to say that I am out of DataBase programming
for quite a long. So I have lost a lot of terminology. Anyway I think
this is a nice place to ask for some help.

Here's the problem.

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.
* 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...
* 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?

I appreciate all of the help from you.

Note, if there is some bibliography that is good for my state of
knowledge, I would like you to pass the link.

Again, Thanks from AA.



Wed, 18 Jun 1902 08:00:00 GMT
 Inporting Data from Informix 4GL to some envirnment in a PC


Quote:
> Anyway I think this is a nice place to ask for some help.

Very kind of you to say so! :-)

Quote:
> 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. :-)

Quote:
> * 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?

Quote:
> * 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.

Quote:
> 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



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Inporting Data from Informix 4GL to some environment in a PC

2. INFORMIX-4GL Compiled / INFORMIX-4GL RDS in the same

3. Exchanging Data between Windows SE on PC with Informix online on AIX

4. Aubit 4gl, Informix-4gl compatible OpenSource GNU compiler project

5. Informix 4GL and ProIV 4GL

6. Problem with TEXT data types when generating report using Informix 4GL

7. Moving table data to structures in Informix-4gl

8. Aubit 4gl, Informix-4gl compatible OpenSource GNU compiler project

9. Informix DBA/4GL/Data warehousing positions

10. Informix-4gl Reports - Question re: Accessing Table Data

11. Power-4gl: Extending Informix-4gl


 
Powered by phpBB® Forum Software