Re: IBM i connection to SQL server databases via SQL or RPG

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Eric

Those are the IBM approaches, also discussed in an article by Kent 
Milligan - title something like "Heterogeneous Data Access" - google on 
that and you should get close.

The Information Integrator named below has been renamed under the 
WebSphere umbrella, I think. It is quite costly, but it offers things 
like federation - where you CAN have tables from disparate RDBMS 
machines look like one database. Very cool!!

Our product, along with some others, is mentioned in that article. The 
article does focus on IBM's solution, of course. It is nonetheless and 
excellent resource.

So you get various choices - Scott's API that is free, something like 
ours that is low to medium cost, with additional features, and IBM's 
which is (was?) pricy but gives full embedded SQL usage.

HTH
Vern

elehti@xxxxxxxxxxxxxxxxxx wrote:
> I thank all of you for your comments.  
> Here is a response from IBM's tech support.
> From: Vivian P Kirkpatrick 
> : Accessing Data on Microsoft SQL Server from OS/400 or i5/OS
>
>  PMR 81473,370,000
>
> Document Title:Accessing Data on Microsoft SQL Server from OS/400 or
> i5/OS
>  Document Description:
>   IBM(r) OS/400(r) and IBM(r) i5/OS(r) support two open standards that
> can be used
> to access Microsoft(r) SQL Server data from an OS/400 or i5/OS
> application.
>
> The first method is through IBM(r) Distributed Relational Database
> Architecture(tm) (IBM(r) DRDA(r)).  OS/400 and i5/OS support DRDA as
> both a client
> (application requestor) and a server (application server).  Although
> DRDA
> is an open standard, Microsoft SQL server does not currently support it
> as
> client or server.  It is still possible to set up a workable
> configuration;
> however, another product is required to convert from DRDA to the SQL
> Server's protocol.  The IBM(r) WebSphere(r) Information Integrator
> product can
> be used for this conversion.
>
> IBM's Information Integrator provides IBM(r) DB2(r) for OS/400(r) with
> access to
> a wide variety of databases.  This includes the DB2 Family as well as
> non-DB2 databases such as Oracle and SQL Server.  DB2 for OS/400
> utilizes
> Information Integrator's capabilities with simple DRDA SQL requests.
> Once
> server mappings and nicknames have been defined in Information
> Integrator,
> the OS/400 SQL requests will look identical to accessing a remote DB2
> for
> OS/400 server.  For more information on configuring Information
> Integrator
> for DB2 for OS/400, refer to the following Web site:
>
> http://www-306.ibm.com/software/data/integration/
>
> A second, more direct method for accessing SQL Server data from an
> OS/400
> or i5/OS application is to use a type 4 JDBC driver for SQL Server in an
> OS/400 or i5/OS Java(tm) program.  At the time this document was
> written,
> Microsoft offered a type 4 JDBC driver for SQL Server 2000 as a download
> from their Web site.  Several other companies also advertise type 4 JDBC
> drivers for SQL Server.
>
> IBM Software
> Technical Document
>
>     Document Number:   15240922
>   ____________________________________________________________
>   Functional Area:                       DB2 for i5/OS
>   SubFunctional Area:               Distributed Relational Database
> Architecture
>   SubSubFunctional Area:       General
>   ____________________________________________________________
>   Product:  I5/OS (5761SS1DB); OS/400 DATABASE (5722SS1DB)
>   Release:  V5R1M0; V5R2M0; V5R3M0; V5R4M0; V6R1M0
>
>   Classification:       Public Use
>
>   Keywords:
>  ____________________________________________________________
>