Re: DB2 to Informix DB connectivity

Posted in 2003

Mohan Natraj — Thu, 15 May 2003 14:27:49 -0700 — source: Usenet: comp.databases.informix

This is a multipart message in MIME format. --=_alternative 0075469888256D27_= Content-Type: text/plain; charset="US-ASCII" Sunil and Serge, To do what Sunil wants to do you will actually need the Informix DRDA gateway. This should take care of the federation need. Sounds like you still want the App on Informix as the main DB and the nickname pointing to DB2. DB2 ESE v8.1 includes an Informix wrapper (brought forward from DB2 v7.2 and known previously as DB2 Relational Connect) and this would work the opposite way. Where the view is created on the DB2 instance and is pointed to a table created in an IDS instance. Depending on what you want to do, you have a couple of choices. Hope this helps. Thanks. Mohan. __________________________________________ WW Brand Manager - XPS and Red Brick IIUG Board of Directors - IBM Advocate Information Management Solutions Tel: 503 525 7419 Fax: 503 721 2369 Address: 315 SW Fifth Av, Portland OR 97204. External e-mail: mogs@us.ibm.com IIUG: Mohan@iiug.org WWW: ibm.com/software/data/informix Serge Rielau <srielau@ca.eye-bee-em.com> Sent by: owner-informix-list@iiug.org 05/15/2003 03:49 AM Please respond to Serge Rielau To: informix-list@iiug.org cc: Subject: Re: DB2 to Informix DB connectivity Hi Sunil, You may want to start here: http://www7b.boulder.ibm.com/dmdd/library/techarticle/0304lurie/0304lurie.html There are alos other articles on federated DBs on developer domain (see link in footer). AFAIK, federation to Informix is covered by your standard DB2 licence. Cheers Serge -- Serge Rielau DB2 UDB SQL Compiler Development IBM Software Lab, Toronto Visit DB2 Developer Domain at http://www7b.software.ibm.com/dmdd/ --=_alternative 0075469888256D27_= Content-Type: text/html; charset="US-ASCII" Sunil and Serge,          To do what Sunil wants to do you will actually need the Informix DRDA gateway.  This should take care of the federation need. Sounds like you still want the App on Informix as the main DB and the nickname pointing to DB2.   DB2 ESE v8.1 includes an Informix wrapper (brought forward from DB2 v7.2 and known previously as DB2 Relational Connect) and this would work the opposite way. Where the view is created on the DB2 instance and is pointed to a table created in an IDS instance. <tt>Depending on what you want to do, you have a couple of choices. </tt> <tt>Hope this helps. </tt> <tt>Thanks. </tt> <tt>Mohan.</tt> __________________________________________ WW Brand Manager - XPS and Red Brick IIUG Board of Directors - IBM Advocate Information Management Solutions Tel: 503 525 7419   Fax: 503 721 2369 Address: 315 SW Fifth Av, Portland OR 97204. External e-mail: mogs@us.ibm.com IIUG: Mohan@iiug.org WWW:  ibm.com/software/data/informix <table width=100%> <tr valign=top> <td> <td>Serge Rielau <srielau@ca.eye-bee-em.com> Sent by: owner-informix-list@iiug.org 05/15/2003 03:49 AM Please respond to Serge Rielau <td>                To:        informix-list@iiug.org         cc:                 Subject:        Re: DB2 to Informix DB connectivity</table> <tt>Hi Sunil, You may want to start here: http://www7b.boulder.ibm.com/dmdd/library/techarticle/0304lurie/0304lurie.html ; There are alos other articles on federated DBs on developer domain (see link in footer). AFAIK, federation to Informix is covered by your standard DB2 licence. Cheers Serge -- Serge Rielau DB2 UDB SQL Compiler Development IBM Software Lab, Toronto Visit DB2 Developer Domain at http://www7b.software.ibm.com/dmdd/ ; </tt> --=_alternative 0075469888256D27_=--

Glossary

IDS (Informix Dynamic Server)