Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

iSeries / AS400 FAQ : (Category) Database : How can I connect DB2 to Oracle or SQL server?

April 26, 2017AS400 category Connect database db2 iSeries Oracle SQL Server

0

Posted

iSeries / AS400 FAQ : (Category) Database : How can I connect DB2 to Oracle or SQL server?

1 Answer

0

Posted

Maybe IBM’s ” DB2 DataJoiner ” can help you? It allows access to SQL Server and Oracle (among other) from different environments. AS/400 is one of these. But in the case of AS/400 I believe it requires having an IPCS in the AS/400 (not sure) This product was announced July 28, 1998. Find its announcement in US Ann.Letter 298-264. At bottom of that page you can request a .pdf file with the announcement. IBM DB2 DataJoiner Version 2.1.1 Other info of interest: IBM DB2 DataJoiner Version 2.1.1 (don’t know if there’s a more updated one…) look into http://www-4.ibm.com/software/data/datajoiner/brochure/index.html Product number: Redbook for Planning SG24-2566 Document: Planning, Installation and Configuration Guide: SC26-9150 Config DBJoiner for DB2 UDB for AS/400 http://www.as400.ibm.com/developer/bi/datajoiner.html (here you get a reference of using it in the AS/400 thru IPCS) DRDA Config (for AS/400): http://www.as400.ibm.com/developer/bi/datajoinersteps4.html Accessing a MS SQL Server