RE: SQL data access

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

Sure.

If your "SQL database" happens to be Oracle/DB2/or another DRDA
compliant database.

--The iSeries can talk to DB2 and other DRDA databases out of the box.

--Oracle offers a product called "Transparent Gateway for AS/400" (BIG
$$$) that allows the Oracle DB to see the iSeries DB as another Oracle
DB _AND_ allows the iSeries DB to see the Oracle DB as another DRDA DB.

--Otherwise, IBM ( and other 3rd parties<?>) (BIG $$$) have products
that install on a PC and use ODBC/ADO/JDBC to connect to the remote DB
while appearing to the iSeries as another DRDA DB.  The IBM product is
called 
"IBM WebSphere Information Integrator".  Why websphere when it is really
a DB2 production I don't know.


Just set up a DDM file pointing to the table.

It's too bad that IBM is the only DB vendor that chooses to use a
publicly published standard protocol to access its database (DRDA).  

HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Skvarenina
> Sent: Thursday, October 19, 2006 2:07 PM
> To: MIDRANGE-L@xxxxxxxxxxxx
> Subject: SQL data access
>
>
>
>
> Is there a tool that could emulate an AS/400 database file 
> but really points
> to a table on a Windows server living in a SQL database so an 
> RPG program
> could simply declare a file from a F spec?
>
> I know the alternative is to invest in a product like 
> DataMirror or Mimix to
> create a duplicate copy of the data on my AS/400 but I'd like 
> to eliminate
> the mirrored copy if possible. 
>
>
>
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.