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

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:
____________________________________________________________