Re: DB2 to Informix DB connectivity

> > > Hi All, > > Recently, our company started using DB2 UDB ESE V 8.1, and one of the > projects is already in the development. > Otherwise, all projects are on different flavours of Informix Dynamic > Server. > Now, there is a urgent need for Database connectivity between Informix IDS > 9.x version to DB2 database. > i.e. a view created on Informix database should be pointing to a table > created in DB2 database. > > Please help me to know how it can be done. > > Thanks much > > Sunil > > Hello Sunil, If you encounter difficulties with the native tools (nformix Enterprise Gateway, DRDA), you may want to check out Virtuoso Universal Server. Virtuoso would certainly allow you to perform the configuration that you have described. Virtuoso also has utilities that would allow you to run heterogeneous join queries against DB2 and Informix tables. And, Virtuoso would allow you to easily snapshot replicate--i.e., migrate--tables from one database to the other, should that be of interest to you. Let me know if you are interested. I can provide you with an overview of the steps that would be involved in any of these undertakings. http://www.openlinksw.com/virtuoso/ Netrista Khatam Technical Services Manager OpenLink Software Universal Data Access Middleware http://www.openlinksw.com