How to transfer data b/w remote Informix NTS 2000 db server to local MySql
Hi friends,
Please help me to find a way to transfer data from a remote infomix database to local MySql database.Using dbacess tool i can make a flat file and later transfer it to my local pc and load data to database.But i need to make a programe which will run 24*7 and after every 1/2 hr load data to local pc.
How can i directly transfer or how to unload data to to flat file on that remote machine which i can get using FTP.When i send 'unload to abc.txt select * from .....' it always says syntax error.I seached on net and found that this statement is used by dbaccess to execute on database and is not a pure sql query.
Also i am not able to get resultset on that specific table because it is always in transaction and i get error 'system can not get information from this table' .It seems that table is locked due to transactions being taking place.
Can i access dbaccess using a java program,telnet or any way that i can get my work done.
Pleeeeeeaaaaaaaase help me out..........
Thanks in advance...........
Rajneesh.
Subject
Views
Written By
Posted
How to transfer data b/w remote Informix NTS 2000 db server to local MySql
10241
January 18, 2006 08:52PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.