Re: Fwd: iNation how-to on getting data from other DBMS

ODBC is not one of the choices we have, for getting data from a non-DB2
database, to the 400. The article mentions some fairly proprietary
products, but it's been a wasteland.

Rather, the article is about the 400 getting data from, say, SQL Server or
Oracle databases. There've been a number of posts here, wondering how to do
this. The 2 techniques discussed are JDBC (which is probably rather slow),
and IBM's DB2 Relational Connect product. As far as the 400 is concerned,
requests are made via DRDA to the Relational Connect server (Windows or Unix).

For now it is read-only, but that should be remedied in future releases.

ODBC IS mentioned, in an incidental manner, as the way that Relational
Connect product makes it's request to another DB.

At 08:45 AM 6/15/02 -0400, you wrote:
>--
>--
>[ Picked text/plain from multipart/alternative ]
>ODBC is very slow right?
>  At some point this may not be the solution of choice.
>
>A. Ports
>--
>To: midrange-l@midrange.com
>From: Vernon Hamberg <vhamberg@attbi.com>
>Subject: iNation how-to on getting data from other DBMS
>Sender: midrange-l-admin@midrange.com
>Precedence: bulk
>Reply-To: midrange-l@midrange.com
>Date: Fri, 14 Jun 2002 23:52:17 -0500
>
>New article on iNation
><http://www.iseriesnetwork.com/article.cfm?ID=14473&channel=home> on
>"Accessing non-iSeries Data from iSeries apps" by Kent Milligan has
>specific procedures for some of the common RDBMS' out there. COOL!